Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Quite new to power bi, trying to do a simple line chart from the sample data above (for one item at a time such as a chart for depreciation) with months in the x axis. can do all sorts of visualisations but not line chart. apparently data is not organised (i.e. months are in columns and line chart doesn't support by default). Any work around? would really appreciate - have spent a few hours researching already - no luck yet.
Thanks
Solved! Go to Solution.
HI @maimal80,
You need to go to que query Editor and chose the columns of the months and unpivot them this will give you your information in a tabular way that the column chart can use easily.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHI @maimal80,
You need to go to que query Editor and chose the columns of the months and unpivot them this will give you your information in a tabular way that the column chart can use easily.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |