Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
For example, we have a print service. For every impression it costs $0.05. Lets say Julie did 1,000 impressions in 2019, her print bill would have been $50..
I want to add something to my dashboard that would allow me to show Julie if she reduced her Print by 200 impressions she would save $10. I'm not sure how to encorporate this sort of graph/slider?
My table of data is as such. The unit price is not in the table, it's a DAX (Number of Impressions X ($0.05))
User | Mono Impressions | Color Impressions |
Julie | 500 | 500 |
Chad | 1000 | 150 |
Jeff | 250 | 300 |
Solved! Go to Solution.
Sounds like you want a What If parameter. Basically it is a table created using GENERATESERIES coupled with a measure that uses SELECTEDVALUE. Found in the What If area of the Modeling tab of the ribbon and is now called New parameter
Hi @sharpedogs ,
You can refer following link to create What-If Parameters in Power BI:
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
Thanks,
Pragati
Sounds like you want a What If parameter. Basically it is a table created using GENERATESERIES coupled with a measure that uses SELECTEDVALUE. Found in the What If area of the Modeling tab of the ribbon and is now called New parameter
the What If statement.... where have you been all my life :)...
Hey Greg,
by the sounds of it, yes that is what i am looking to accomplish. But my skillset is not yet there with respect to creating it. I'm reading two books at the moment (one of DAX and one on visualizations). Parameters havn't yet come up, is there by any chance a Youtube video you can recomend?
I'll also take a look today on YouTube for parameters. I didn't understand prior to your comment how that would have helped me.
Hi @sharpedogs ,
You can refer following link to create What-If Parameters in Power BI:
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
Thanks,
Pragati
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |