topic Re: Bar Graph & Month Column Issues in Custom Visuals Development Discussion

Bar Graph & Month Column Issues

JKFX001 — Wed, 06 Apr 2022 23:03:34 GMT

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.

Re: Bar Graph & Month Column Issues

KerKol — Sat, 23 Apr 2022 11:06:33 GMT

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

Re: Bar Graph & Month Column Issues

KerKol — Thu, 07 Apr 2022 07:05:10 GMT

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

Re: Bar Graph & Month Column Issues

KerKol — Thu, 21 Apr 2022 12:07:17 GMT

Any luck?

Re: Bar Graph & Month Column Issues

JKFX001 — Thu, 28 Apr 2022 21:10:36 GMT

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?