Forum Discussion
Helper IFiltering the values in a slicer
I got a requirement where i need to filter the slicer values based on a measure.
The slicer has to show the list of values which are getting displayed in the Finished Goods column[marked].Please help me solve the issue.
Thanks in advance
You can try using the following to filter the values in the slicer:
Filter slicer = COUNTROWS (RELATEDTABLE (Fact table))
Add the measure to the filter pane for the slicer and set the value to greater or equal to 1
4 Replies
- amitchandak
Super User
SushmaReddy , Not very clear. But we use measure in the visual level filter and check not blank . In the visual level filter
SushmaReddyHi Amitchandak,
Thanks for the reply,ya i tried using the measure which i used in the table visual in the the slicer visual also but it is not working.
The table visual is filtered using a measure by comparing C1- Tab1 with C1 -Tab2 but the column which is used in the slicer is C2-Tab1 which doesnt have a common column in T2.Pls help me to proceed further
- v-luwang-msft
Community Support
Hi
Could you pls share the output result what you expect?
Best Regards
Lucien
PaulDBrownCommunity Champion
You can try using the following to filter the values in the slicer:
Filter slicer = COUNTROWS (RELATEDTABLE (Fact table))
Add the measure to the filter pane for the slicer and set the value to greater or equal to 1
