Forum Discussion
Solved
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 wi...
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.
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.