Alternate states functionality

v-jiascu-msft

Hi Dale,

Thanks for the reply. I will definitely submit it as an idea. The real-case scenario I'm facing is that the end users developed their BI reports in another tool for demo purposes, but given that they are entitled to Power BI on-prem, they would like to replicate these reports and deploy them, instead of buying another piece of software. Main goal of these reports is to be able to dynamicaly compare different scenarios. Data warehouse structure looks something like in the attached photo.

So, the thing they would like to accomplish is represented in another photo. I could not use real data, so I had to create a quick mockup. The idea is to have 3 pairs of slices (scenario-year), and by choosing the wanted combination, graph on the right would change and display 3 different lines for the selected combination. I solved this particular problem by combining these 6 slicers into one, and using the scenario-year combination as the slicer value. However, beside the line graph, existing reports were also able to display the KPI value based on these same slicires. So, if one was to choose scenario 1-year 2017 for one slicer pair, scenario 2-year 2017 for the other, and scenario 3-year 2016 for the third, two values in the report that represent KPIs (case 1 vs case 2 and case 1 vs case 3) would change accordingly. This is the part that I cannot figure how to solve. I have hard coded for the case of comparisson between current and previous year, but that was all. 

Any additional ideas are most welcome.