How can I use the same field in 2 different visuals at the same page (slicer) with different data?

[stefanomaviega]

How can I use the same field in 2 different visuals at the same page (slicer) with different data?

Let me try to me more specific, I have a column called category  with several types of categories.

I want to have a slicer only filtering for example 2 categories (indexes, also changed the name of the second slicer) and have another slicer showing the rest of the items and the idea is to  allow the user to have for example one option picked on slicer 'indexes' with only a few options and also select the rest of the data from the other slicer where they can show this data "combined".

So the users can always pick one of the indexes separated from the original slicer but also combine with the other slice in a line graph visual.

Is it possible?

Thanks

Stefano

[aj1973]

Hi @stefanomaviega 

If I am not mistaken, you want to select an Index and see only the related Category to that Index!

This depends on how the relationship is set in your model, so if the 2 fields belong to 2 Tables that are related then change the relationship to both. if not then you will need a DAX formula. 

[stefanomaviega]

Hello Amine,

I only have 1 table with a column called category where I have for example 100 lines, 2 of these lines are indexes that always need to appear in the line graph to be compared with the rest of the other 98 lines.

My idea is to have a slicer called indexes only showing these 2 lines from the same column category with a different name and another slicer called category showing the rest of the 98 items where the user can pick one ore more lines from slicer called category and also pick from slicer called indexes one of the indexes so he can have a comparison between these items and the indexes.

The problem is, when I create the second slicer with the same column and I filter only the 2 lines that I call index the other slicer with the rest of the 98 lines does not show the other items anymore.

[aj1973 · Accepted solution]

Hi Stefan,

A slicer needs A column, You can add a calculated column cloned from Category column and name it Index. Then from Index use Filter Pane to filter out the lines you don't want to see. like here

[stefanomaviega]

Thank you very much sir!

[aj1973]

Welcome