Forum Discussion
Calculating difference based on selected slicer values
Hello Everyone,
I had been trying to make a comparision matrix visual that includes the calculated quantity values on the difference between two versions that are selected from "version" slicer created in Power Bi. How can I achieve that?
E.g I am intending to display the quantity values of the selected versions as well as the calculated quantity value the differents for all the months in a single matrix table and the table will change dynamically as I choose another "version" from the slicer. The excel file below is the outcome that I want to achieve in Power Bi. Thank you in advance!
Link to data (actual and plan worksheets)
https://drive.google.com/file/d/1g-n-FP4FHW0p1NT-POMdZZxKh7x8qZUo/view?usp=sharing
3 Replies
lywnnn , if you need to show diff between two slicer values from two slicers. One of the slicers needs to come from an independent table
I have discussed an example for a date here
How to use two Date/Period slicers:https://www.youtube.com/watch?v=WSeZr_-MiTg
Hi Amit, my intention is to show the difference based on the 2 selected values in a single slicer.
Hi lywnnn ,
I can't access to the shared file link, could you please provide some sample data andyour expected result with Text format if sharing files is unsuccessful?
https://drive.google.com/file/d/1g-n-FP4FHW0p1NT-POMdZZxKh7x8qZUo/view?usp=sharing
In addition, you can refer the content in the following links to get it.
Comparison of a plan and a reality in Power BI
Best Regards
