Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thank you very much sir!
Welcome
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
83 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
129 | |
108 | |
63 | |
55 |