Bar Graph & Month Column Issues

[JKFX001]

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.

[KerKol · Accepted 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

[JKFX001]

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?

[KerKol]

Then you can use a single date field to create your bar graph

[KerKol]

Any luck?