Calculating difference based on selected slicer values

[lywnnn]

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

[v-yiruan-msft]

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

Compare Plan and actual data

Best Regards

[amitchandak]

@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

[lywnnn]

Hi Amit, my intention is to show the difference based on the 2 selected values in a single slicer.