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

workaround 1:

add ""New MaxStatusas Number 3" in the Visual level filter, select 0/1/2 in the filter

 

workaround 2:

1.create a table (enter data), don't connect to any table

2 create a measure 

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

3.add measure in the visual level filter, select "1"

add Table1[slicer] in the slicer

 

 

This only support single selection.

 

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey v-juanli-msft,

 

many thanks for your fast reply! 

 

I really like your second workaround proposal! Would it be possible to show "green", "red", "yellow" instead of the 0,1,2 in the slicer?

 

I tried to create a new table and rewrite the measure, unfortunately without success...

 

I would really appreciate your help!

 

Many thanks,

 

Adam