How to switch column categories when switching between categories in filter?

[Anonymous]

Dear Community 🙂

I have created a matrix table with a slicer on a variable called 'Segment', which can either take on 'Product Tankers' or 'Crude Tankes'

My problem is that when 'Segment'='Product Tankers' I need one set of column names (from a column called 'Product Segment') and when 'Segment'='Crude Tankers' I need a different set of column names (from a column called 'Crude Segment') to be displayed in the matrix. 

Can anyone help me to link different column names to the categories in a slicer?

So that when I choose 'Product Tankers' from the segment filter I get column names from the variable 'product_segment' and when I choose 'Crude Tankers' from the segment filter i get column names from the variable 'crude_segments'.


I have attached pictures to describe my problem:


So when I choose ' Products Tankers' it works correct:

But when I choose 'Crude tankers' the column names are wrong as they refers to product_segment:

Instead I need this when I choose 'Crude Tankers':




Thanks in advance 🙂 

[Anonymous]

Thank you so much 🙂

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

You could group them in a field parameter and filter from one to another using a slicer, check this link for instructions 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