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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
JL0101
Helper II
Helper II

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 II
Helper II

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors