Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi Everyone,
Asking for help and suggestion about comparing same column from same table but filtered differently in visuals using slicers and interaction.
What I did was I created 2 set of slicers and 2 visualization. Using interaction, I set the 1st slicer to interact only with the 1st visual and the same for 2nd slicer to interact only to the 2nd visual. With this, I was able to have separate data from my visuals using slicer even if it is sourcing from same column and table. However, I want to compare the data that was appearing in the visuals. Does anyone here have idea to do it?
For reference:
Column Name | Using Slicer 1 | Using Slicer 2 |
A | 20 | 30 |
Comparison I want | 2nd | 1st |
Solved! Go to Solution.
Hi @robertsarza ,
You need to create another 2 slicer tables first;
Then create a dimension table as below:
Finally create 4 measures as below:
salary1 = IF(ISFILTERED('Slicer 1'[age]),CALCULATE(MAX('Table'[salary]),FILTER('Table','Table'[age]=SELECTEDVALUE('Slicer 1'[age]))),MAX('Table'[salary]))
salary2 = IF(ISFILTERED('Slicer 2'[age]),CALCULATE(MAX('Table'[salary]),FILTER('Table','Table'[age]=SELECTEDVALUE('Slicer 2'[age]))),MAX('Table'[salary]))
Sliced value =
SWITCH(SELECTEDVALUE('Dimension table'[slicers]),
"slicer1",'Slicer 1'[salary1],
"slicer2",'Slicer 2'[salary2],BLANK())
Rankx = RANKX(ALL('Dimension table'),'Dimension table'[Sliced value],,DESC,Dense)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @robertsarza ,
You need to create another 2 slicer tables first;
Then create a dimension table as below:
Finally create 4 measures as below:
salary1 = IF(ISFILTERED('Slicer 1'[age]),CALCULATE(MAX('Table'[salary]),FILTER('Table','Table'[age]=SELECTEDVALUE('Slicer 1'[age]))),MAX('Table'[salary]))
salary2 = IF(ISFILTERED('Slicer 2'[age]),CALCULATE(MAX('Table'[salary]),FILTER('Table','Table'[age]=SELECTEDVALUE('Slicer 2'[age]))),MAX('Table'[salary]))
Sliced value =
SWITCH(SELECTEDVALUE('Dimension table'[slicers]),
"slicer1",'Slicer 1'[salary1],
"slicer2",'Slicer 2'[salary2],BLANK())
Rankx = RANKX(ALL('Dimension table'),'Dimension table'[Sliced value],,DESC,Dense)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!