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.
Hello,
I have a table of items and their costs forecasted over the next 12 months.
I'm trying to show this data in a bar graph, however, since the months are represented in indivual columns, I'm having to put each month in the 'values' field, which comes out showing the bars super close together and no titles on the x axis.
I would like 12 separate bars, with the name of the month below on the x axis.
Maybe I'm using the wrong visual?
Since this data is coming from excel, I've tried creating a new table to link to Power BI. However, having months as columns is proving to be difficult to work with in both...
any tips are appreciated.
Solved! Go to Solution.
You'll need to pivot your data in Power Query
How to Unpivot in Excel with Power Query + Video Tutorial (excelcampus.com)
Unpivot And Pivot Basics In Power BI - Query Editor Review - Enterprise DNA
Proud to be a Super User!
Any luck?
Proud to be a Super User!
Then you can use a single date field to create your bar graph
Proud to be a Super User!
You'll need to pivot your data in Power Query
How to Unpivot in Excel with Power Query + Video Tutorial (excelcampus.com)
Unpivot And Pivot Basics In Power BI - Query Editor Review - Enterprise DNA
Proud to be a Super User!
Thank you! that was super helpful and definetly acheived what I needed.
However, this month there were a few changes to the line descriptions and now I'm receiving errors in the unpivoted data and I'm not sure how to fix it. Not sure why it just didn't update normally, are you familiar with any other videos that might address refreshing data or errors in unpivoted data?
Covering 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.