Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |