Forum Discussion
Create a multiple line chart per Country level
Hi All 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. Exp...
Hi Anonymous ,
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
Vietnam 2019Q2 5 Vietnam 2019Q1 4 Vietnam 2018Q4 3 Vietnam 2018Q3 -2 Vietnam 2018Q2 1 Thailand 2019Q2 6 Thailand 2019Q1 7 Thailand 2018Q4 8 Thailand 2018Q3 5 Thailand 2018Q2 3 China 2019Q2 2 China 2019Q1 3 China 2018Q4 4 China 2018Q3 10 China 2018Q2 5 Cambodia 2019Q2 5 Cambodia 2019Q1 4 Cambodia 2018Q4 3 Cambodia 2018Q3 2 Cambodia 2018Q2 1 Indonesia 2019Q2 -4 Indonesia 2019Q1 -5 Indonesia 2018Q4 4 Indonesia 2018Q3 3 Indonesia 2018Q2 1 With this query result you can create your multiple line visual and sort it by quarter:
Voila!
Thanks a lot for the solution! It works like a charm!
Mariusz Anonymous