Forum Discussion

HamidBee's avatar
HamidBee
Power Participant
2 years ago

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

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.

Need Help
Show and Tell

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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