Two Slicers from the same column to filter Matrix Columns

[bp107]

Hello! Thanks in advance for any assistance.

I am using a switch function to have a slicer that changes the columns visible in a matrix visual.

I have create a "Mapping" table and I am using all of the matrix column headers from that table and the values are based on the formula below.

Example of the Values formula: =Switch(Max(mapping[Columns]), "Column 1", Max(Column 1), etc.)

I have a slicer with all of the Column headers in it and I can filter the columns visible in the matrix with the slicer. However there are 2 types of columns in the data. One is the Product Data. The other type is the Calculations for the Product.

I want to have 2 slicers that both filter the matrix columns. One slicer for the Product Data Columns. One slicer for the Product Calculations. 

I was able to create 2 slicers with the Mapping[Columns] as the values. I am able to use the visual filter to only show the specific column option I want in wach filter. However, when I try to select one column from each slicer, the matrix is then blank.

Any recommendations or help?

[Ritaf1983]

Hן @bp107 
If I understand you correctly and what you want is to give the user the option to select the columns to display, then a normal slicer is less able to accomplish this, since its primary function is to filter values within a column.
In order to display specific columns or measures, you can use the
The field parameters.
I have attached a link to how to use them.
https://www.youtube.com/watch?v=V6WchPDZibI&t=128s

It would be helpful if you could attach a sample file and a picture of your desired result if I did not understand what was requested.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bp107]

When I tried to use the field parameters, I was not able to use them in a matrix. 

I am using the switch function to be able to have different columns selected. My main question is, how do I get 2 slicers on the same column? Here is a made up example.

I added this table and created this function for the column headers in the matrix.

Then I created a matrix with the columns. and then 2 slicers. 1st slicer is 1,2,3,4. 2nd slicer has 5,6,7. I edited the interactions so they don't filter each other. 

But when I select a couple from the 1st slicer, if I select one from the 2nd slicer, everything just goes blank. How can I get this to work??

Note: my real work is 88 column options so I am working to get them split up some to prevent confusion.

[Stefanos_Ch · Accepted solution]

Hi there, 

I managed to to find a solution for splitting a column into 2 slicers. Give it look and let me know!

https://www.linkedin.com/posts/stefanos-chantzis-83b765140_powerbi-slicer-dataanalysis-activity-7099...

[Ritaf1983]

It is important to note that I still did not fully understand your request, so I will attempt to address only the question about two slicers.

Two slicers cannot use the same column.

It is necessary to prepare two separate tables for each slicer in the data.

Link each one to your fact table.

One table is represented by 1 to 4 in your example.

Table 2 for 5 and more
Use This 2 dims as a slicers.
It is my hope that this is clear, but if not, I can prepare an example tomorrow.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.