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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
aulona12
Frequent Visitor

How to toggle between two column version in the Matrix?

Hello everyone, 

 

I am using the Matrix to show to tables that have the same index, called category and for the columns there are two versions "Date Option A" and "Date Option B" 

 

They look like this : 

 

aulona12_0-1695927703095.png

 

 

Is there anyway that i can create only one matrix in power bi instead of two and just give the viewers the option to toggle the columns between "Date Option A" and "Date Option B" 

 

They insist that they do not want to separate tables but instead just one and have the option to toggle between those two date versions. Let me know if this is possible and thanks in advance for any help that you can provide! 

 

 

1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

Hello @aulona12 ,

 

Try grouping the two record in a field parameters and they can switch between both fields in a slicer.

 

check the field parameters https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

4 REPLIES 4
Idrissshatila
Super User
Super User

Hello @aulona12 ,

 

Try grouping the two record in a field parameters and they can switch between both fields in a slicer.

 

check the field parameters https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Let me try this. I'll get back to you

POSPOS
Post Patron
Post Patron

@aulona12  : You can place the Column with  "Date Option A" and "Date Option B"  values in the 'Columns' section. With this you will have one table and the data will be seggreagated by Option A and Option B.

POSPOS_0-1695928250970.png

 

They do not want this. They do not want to see both of those options at the same time. They want to have the ability to toggle back and forth but not see them at the same time, segregated like you are suggesting

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Kudoed Authors