Forum Discussion
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 th...
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