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.

[srt1111]

Hi Rena, Thank you for your respond. However it didnt give the answer im looking for. The report graph from each group slicers (workload 1 and workload 2) need to be combined/stacked in to one main graph (with different colour perhaps). If i need to create a DAX function, how should it be written? Workload 1 and workload 2 are a group of slicers created via bookmarks. Also, im wondering if i need to duplicate my model for each workload?..

[Anonymous]

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