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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.