Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have two slicers with the same column 'Table'[reference] and I want to see only unselected values from slicer one in slicer two. I have
Solved! Go to Solution.
Hi, @DanishNadeem
You can try the following methods.
Sample data:
New table:
Table 2 = VALUES('Table'[Reference2])
Measure =
Var _table=CALCULATETABLE(VALUES('Table'[Reference1]),FILTER('Table',[Reference1]<>BLANK()))
Return
IF(SELECTEDVALUE('Table 2'[Reference2]) in _table,0,1)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
One can never imagine how weired requests on forum can be.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
One can never imagine how weired requests on forum can be.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Hi, @DanishNadeem
You can try the following methods.
Sample data:
New table:
Table 2 = VALUES('Table'[Reference2])
Measure =
Var _table=CALCULATETABLE(VALUES('Table'[Reference1]),FILTER('Table',[Reference1]<>BLANK()))
Return
IF(SELECTEDVALUE('Table 2'[Reference2]) in _table,0,1)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DanishNadeem ,
With jus the information provided, use the below formula as a visual filter = is not blank
=
CALCULATE (
COUNTA ( 'table'[Other References] ),
FILTER (
'table',
NOT 'table'[Other References] IN VALUES ( 'table'[Promocode References] )
)
)
Please take note that a previously selected item that is no longer visible because of the change in slicer 1 selection will still be visible in slicer 2 unless deselected. Deselection of non-visible items is not automatic.
Proud to be a Super User!
Hi @danextian , I am getting nothing(no values) when I applied visual level filter = is not blank
User | Count |
---|---|
129 | |
73 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |