The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
107 | |
75 | |
61 |
User | Count |
---|---|
276 | |
129 | |
122 | |
100 | |
88 |