Power BI Line chart visual

[shansakhi]

Hello ALl,
Need your assistance to to create below Line Chart in Power BI visual.
I tried, but unable to add "As on date" as column filter like excel.
Please guide me to do it.

Forecast Post RMA_1.xlsx
	A	B	C	D	E
8		7/31/2023		7/17/2023
9	Flight Date	FRCT%	BKD%	FRCT%	BKD%
10	8/1/2023	85%	86%	75%	59%
11	8/2/2023	80%	79%	69%	53%
12	8/3/2023	82%	81%	73%	54%
13	8/4/2023	81%	77%	73%	55%
14	8/5/2023	83%	76%	70%	52%
15	8/6/2023	81%	73%	68%	49%
16	8/7/2023	77%	66%	67%	44%
17	8/8/2023	80%	63%	68%	43%
18	8/9/2023	78%	62%	67%	44%
19	8/10/2023	83%	67%	73%	49%
Date Level

Regards,
Shan

 

[shansakhi]

Hello All,
Can anybody assist for this.

 

[GooberTron]

To get that kind of chart in Power BI you will probably need a data layout that looks like this:

The transformation steps I used in Power Query to do this was:

let
    Source = Excel.Workbook(File.Contents("C:\Users\GooberTron\Desktop\Power Query Tests\shansakhi.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Transposed Table" = Table.Transpose(Sheet1_Sheet),
    #"Filled Down" = Table.FillDown(#"Transposed Table",{"Column1"}),
    #"Merged Columns" = Table.CombineColumns(#"Filled Down",{"Column1", "Column2"},Combiner.CombineTextByDelimiter(" - ", QuoteStyle.None),"Series"),
    #"Transposed Table1" = Table.Transpose(#"Merged Columns"),
    #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table1", [PromoteAllScalars=true]),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Promoted Headers", {" - Flight Date"}, "Attribute", "Value"),
    #"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{" - Flight Date", "Flight Date"}, {"Attribute", "Series"}, {"Value", "Percent"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Series", type text}, {"Percent", Percentage.Type}}),
    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Changed Type", {{"Flight Date", type text}}, "en-US")
in
    #"Changed Type with Locale"

You will need to adjust the Source steps and perhaps you won't need the "Changed Type with Locale". But it gives you an idea of how it works. If you can fix your data layout at source, then it might be easier to do that.

I got this chart from your example data:

 

[shansakhi]

Thank you for the solution/hint.