Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JL0101
Helper I
Helper I

How to dynamically change columns in a matrix via a selector

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 ?

 

JL0101_0-1686056591151.png

 

 

 

4 REPLIES 4
JL0101
Helper I
Helper I

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 

lbendlin
Super User
Super User

You are describing the functionality of Field Parameters.

 

Also consider allowing "Personalize visuals" and teach your users how to use it.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.