Calculate difference while using Field parameters

Power BI
1

*** READ FIRST ***
Hi All, I am using Field parameters to get total qty, total qty last year, and same for total sales , total sales last year using field parameters. How can I calculate the difference in percentage dynamically when the user selects either Qty / Qty last year or Sales / Sales last year.
Pls see the image below:

Qty and Sales
Qty and Sales1190Ă—655 222 KB

2

Hi @chris786 ,

Thank you for reaching out to the community.

While we wait for other members to share their insights, I’ve taken the liberty of using “Explain Simply,” one of the tools available within Data Mentor (you can explore it here: [https://mentor.enterprisedna.co/explain-simply ]. It generated the following results:.

image
image1537Ă—955 107 KB

Feel free to checkout more of our Data Mentor features as you work on your report. These tools are designed to help with tasks like the one you’re working on, and they might accelerate your learning curve.

Cheers,

Enterprise DNA Support Team

3

Hi @chris786 - Don’t think this is how field parameters work. Best option according to me will be to create percentage/other measures and add as option on Field parameters, so they show on visual on user Selection.

Thanks
Ankit J

4

Thanks Ankit, didn’t think of that one…life saver…:blush:

1 Like