Unstructured Table

Hi Anonymous ,

Before generating any trend/line chart, you will have to modify the structure of the data, so that you can have a DATE column on your x-axis on the chart.

For this what you can do is following:

1. Go to Edit Query section.
2. Naviagte to the data-set that you have shown below.
3. Select all the date columns - 2020 to 2028.
4. Go to Transform and Unpivot the selected columns.
5. You will send up with following columns:
   • Markets
   • Keys
   • Attribute
   • Value
6. Attribute column will have date values - 2020 to 2028. Rename this column to DATE or whatever you want.
7. Now you can use this column to generate some trend chart.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

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/

Hi Anonymous ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards,
Icey