Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

    Vietnam2019Q25
    Vietnam2019Q14
    Vietnam2018Q43
    Vietnam2018Q3-2
    Vietnam2018Q21
    Thailand2019Q26
    Thailand2019Q17
    Thailand2018Q48
    Thailand2018Q35
    Thailand2018Q23
    China2019Q22
    China2019Q13
    China2018Q44
    China2018Q310
    China2018Q25
    Cambodia2019Q25
    Cambodia2019Q14
    Cambodia2018Q43
    Cambodia2018Q32
    Cambodia2018Q21
    Indonesia2019Q2-4
    Indonesia2019Q1-5
    Indonesia2018Q44
    Indonesia2018Q33
    Indonesia2018Q21

     

    With this query result you can create your multiple line visual and sort it by quarter:

     

    Voila!

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

Please see the attached file with the solution.

All you need to do is use Unpivot on all Quarter column instead of the Transpose.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski