Forum Discussion
Grizzlydad
Helper I
Helper ICreate same line chart that is already in excel
Hi all I am trying to create the same line chart that is pictured in Power Bi desktop, using the line chart visual. I can't get it to exactly replicate. You can see it works as expected in excel. ...
I think you have clicked on the "Unpivot Columns" instead of "Unpivot Other Columns" (see picture).
This is the output you'll see:
Hope it helps,
PDG
- Perfect, thanks for all your help!
GrizzlydadHelper I
Helper IYes this has worked, thank you. However can I order the axis to have the days in the correct order so Monday to Sunday or similar, at the moment it is a bit random showing Friday, Monday, Saturday, Sunday, Thursday, Tuesday and Wednesday?
Thnaks again
P_D_G
Resolver III
Resolver IIICustom sort order of values:
https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi
NB: You need to use the column fromt the 2nd column (only containing the days &custom sort order) in your visual!
Best,
PDG
- GrizzlydadPerfect, thanks for all your help!