Forum Discussion
Need help for dashboard
Hi, is there a way to present this in a stacked bar chart?
Revenue, profit and expenses in slicer. Qtr 1 and 2 in filter. Eg. When revenue is selected from the slicer, the stacked bar chart will show revenue of Outlet A & B in Qtr 1 and 2, respectively (so 4 bars in total).
Also, in the case where there is eg. 1000+ outlets, what is the best way to present this data? Thanks!
jun_9644 You could unpivot your Revenue, Profit and Expenses columns in Power Query. Then you will have Attribute and Value columns. You can then use the Attribute column for your slicer. You can add Outlets and then Period to the x-axis and use the forked arrow to drill down to the Period level.
1 Reply
jun_9644 You could unpivot your Revenue, Profit and Expenses columns in Power Query. Then you will have Attribute and Value columns. You can then use the Attribute column for your slicer. You can add Outlets and then Period to the x-axis and use the forked arrow to drill down to the Period level.