Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Unstructured Table

Hi Team, Thank you so much for your help, now I have another query... How can I work on Trend Analysis/Line chart in the below one. Thanks, Kali

lkalawski
6 years ago
Hi Kalidass,

To create a trend chart, you have to unpivot the table.
You will get this view and then use year and Value to build a trend line.
Result:

_______________
If I helped, please accept the solution and give kudos! 😀

Icon for Super User rank

Super User

6 years ago

Anonymous

Unpivot the data create tables/dimensions for the Market, Keys and year to create star schema model

https://radacad.com/pivot-and-unpivot-with-power-bi

Market = distinct(all(Table[Market]))

Keys= distinct(all(Table[Keys]))

Year= distinct(all(Table[Year])) //You will get after Unpivot

Join them back with table

Refer:https://docs.microsoft.com/en-us/power-bi/guidance/