Forum Discussion
Numerical Slicer help
I have a Table visual that shows:
There are extensive filters applied to what serial numbers show up for the count. What I'm trying to do is build a slicer (slider) that allows me to slide between the values in the count - so basically letting me filter by the number in the count to see how many customers have that number. Thoughts?
Howabout:
1. user a parameter
2. use a measure to count the Serial_No, and if it does not equal the parameter then set to blank
3. sort the measure column with highest number at the top (so blanks will show at the bottom out of the user's way)
But I don't know how to filter out the blanks because this a calculated measure - anyone else?
Alternatively in the backend you could create a calculated table - giving a unique Customer_No in one column, and the Count of Serial_No in the second column. With the output visualisation you could then use a slicer on "Count of Serial_No" because it is a calculated column rather than a calculated measure.
Does that help?
CM
1 Reply
Howabout:
1. user a parameter
2. use a measure to count the Serial_No, and if it does not equal the parameter then set to blank
3. sort the measure column with highest number at the top (so blanks will show at the bottom out of the user's way)
But I don't know how to filter out the blanks because this a calculated measure - anyone else?
Alternatively in the backend you could create a calculated table - giving a unique Customer_No in one column, and the Count of Serial_No in the second column. With the output visualisation you could then use a slicer on "Count of Serial_No" because it is a calculated column rather than a calculated measure.
Does that help?
CM