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.
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
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
@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.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |