Help Needed with Creating Line Graphs for Business Unit Indicators Over Quarters

[HamidBee]

Hi All,

I am working with some data for a company that has business units and then subcategories. Within those subcategories there are indicators. I would like to plot a line graph to showcase these indicators over Q1, Q2, Q3 and Q4. So for example it should look something like:

I can't seem to get it right. Here is how mine looks like. I even tried to create a measure but it comes out the same. Here is how it looks like:

Please find attached the file:

https://www.mediafire.com/file/09el2lbu8932sqr/Report.pbix/file

Any help would be greatly appreciated.

[amitchandak]

@HamidBee , In such case best to have Q1, Q2, Q3 and Q4 has rows not has column .

Do unpivot that

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Or create a calculation group by creating 4 measures Q1, Q2, Q3, and Q4.

And use that on the axis

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0