Forum Discussion
How to Use Slicer for Measure Values
Hello,
I am trying to have a slicer/chiclet slicer that will filter some values in my table. The #Aired values is a measure:
Show # Aired
ABC 1
345 8
XYZ 6
I want to have a selection that is '1+' and '3+'. If i select '1+' that would be all the shows and if i select '3+' I can only see the last two shows. How can I set this up?
Thanks!
Hi Anonymous ,
Does that meet your requirement?
Measure = var a = MAX(Slicer[#Aired]) return IF( a<=SUM('Table'[aired]),1,BLANK())Pbix as attached.
Hi @QuanitaA ,
Does that meet your requirement?
Measure = var a = MAX(Slicer[#Aired]) return IF( a<=SUM('Table'[aired]),1,BLANK())Pbix as attached.
5 Replies
Hi Anonymous ,
As we know, we cannot add measure to a slicer directly. We can use what if parameter to work on it. please refer to the following steps as below.1. Create a what if parameter like this.
2. To create a measure and make the table visual filtered by it.
Measure = IF([# Aired]>=Parameter[Parameter Value],1,BLANK())For more details, please check the pbix as attached.
Thanks for your response. The challenge is we have a lot of data on shows and how many times they've aired. We only really need a view that splits it into '1+' and '3+'. Is it possible to get something like this?
So 1+ would show everything on the list and 3+ would show the last two as well as a show that aired exactly 3 times.
Thanks,
Quanita
Hi Anonymous ,
Does that meet your requirement?
Measure = var a = MAX(Slicer[#Aired]) return IF( a<=SUM('Table'[aired]),1,BLANK())Pbix as attached.
Anonymous
Why can't use expose the visual filter to the users to keyin the value with "is greater than or equal to" condition?
