The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, What is the best way to dynamically change columns in a matrix via a selector, If I want to compare 2 volumes colums from 2 different dates? I don't want to create 2 measures for the date selector for this to work. So firstly the user selects a date for 1 column and a date for another, it automatically displays the values for these columns and the difference between them. Secondly the user can change from Volumn, to Area to Length in another slicer with the comparison functionality working for it?
Is this a candidtate for calculated groups or can I use selected value ?
I couldn't see how to get it working with field parameters. I tried this method https://www.youtube.com/watch?v=40AZos5hjko but it it would only create a manay to many reationship between the 2 date tables.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Unfortunatley there is no easy way to share the data, however I will continue to review it
You are describing the functionality of Field Parameters.
Also consider allowing "Personalize visuals" and teach your users how to use it.
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 |
---|---|
99 | |
90 | |
82 | |
64 | |
58 |
User | Count |
---|---|
244 | |
128 | |
118 | |
79 | |
78 |