Dusty Ryan shows off What-If Analysis in Power BI:
Next, I’m going to create a calculated measure that multiples Revenue Last Year by Revenue Target % Value. Here’s the formula for the calculated measure:
Revenue Target = [Revenue Last Year] * [Revenue Target % Value]
Now I’m going to add this new measure, Revenue Target, to my line chart. And now when I use my slicer slider bar, I can dynamically change my Revenue Target line on the chart!
This is pretty cool. Definitely check out Dusty’s example; it’s something that might make many an executive happy.