Comparison of two different KPIs on a single report page based on user selection
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!