Comparison of two different KPIs on a single report page based on user selection

[enzo_357]

Hi!

I have a big dataset with more than 50 KPIs in it. The KPIs can have different data formats ($, whole numbers, percentages,...). The report consumers want to be able to select any two KPIs of the model and have the trend of these two KPIs shown on a single report page.

How can I do this? I can design a page where users select only one KPI using calculation groups (according to: https://www.sqlbi.com/articles/introducing-calculation-groups/ I use calculation groups, because the KPIs have different data-formats).

But I couldn't figure out how to design a page, where the users can chose two KPIs....

Thanks for your help in advance! 

[mwegener]

Hi @enzo_357 ,

you could divide the report page into two sections and control them with separate slicers.

You have to set the interaction between Visual and Slicer accordingly.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions