How to toggle between two column version in the Matrix?

[aulona12]

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 : 

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! 

[Idrissshatila · Accepted solution]

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 💡

[aulona12]

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

[POSPOS]

@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.

[aulona12]

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