I am learning power BI currently and had just started since 2 days ago. I am trying to figure out on how to create a line report which showing the values per quarter by country level.
Sample data as follow:
I couldnt get it works unless I transposed the table into below:
However if the table transposed as above, i couldn't add the country as filter, only quarter..
Is there any way to create the multiple Line chart per countries which filterable by the countries?
Go to Solution.
Hi @Tomsg89 ,
at first you need to unpivot the last 5 columns of your original data ( > Transform > Unpivot columns) so that you get a table like this:
Country Quarter Value
With this query result you can create your multiple line visual and sort it by quarter:
View solution in original post
Please see the attached file with the solution.
All you need to do is use Unpivot on all Quarter column instead of the Transpose.
Thanks a lot for the solution! It works like a charm!
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!