Merging 2 graphs from different set of slicers into a stacked column chart

[srt1111]

Hi,

I want to create a new report in PBI where the customer wants to have a report that has 2 graphs/tables ( example given: workload 1 and workload 2) with each has its set of slicers - sort of a template slicers (picture 1). The output of these 2 graphs need to be stacked into one view i.e one stacked column chart (picture 2).

This is so challenging to me, because the 2 graphs/ tables are not fixed, it can be changed by customer at their requirement.

How to do this? 

Thank you and regards.

[v-yiruan-msft]

Hi @srt1111 ,

You can get it by creating bookmarks and stacked column chart:

Create page and bookmark navigators - Power BI | Microsoft Learn

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

Best Regards