Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure as Slicer - Workaround?

Hey guys,   do you have maybe an idea for a workaround, how a measure could be used as a Slicer?   I created a measure called "New MaxStatusas Number 3" that is changing based on the timeline Sli...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    Create the new table as below

    create the measure

    Measure = IF([new MaxStatusas Number 3]=SELECTEDVALUE(Table1[number]),1,0)

    add measure in the visual level filter

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

Create the new table as below

create the measure

Measure = IF([new MaxStatusas Number 3]=SELECTEDVALUE(Table1[number]),1,0)

add measure in the visual level filter

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • bo_afk's avatar
    bo_afk
    Post Patron
    6 years ago

    Hi v-juanli-msft 

     

    Do you always need to select a filter value for results to appear? I have a similar scenario and created this measure slicer as suggested by you. But when no slicer selection is made, my results are empty. Is it possible to have it such that when no selection is made, it defaults to everything being selected?

     

    Thanks!

    afk