cancel
Showing results for
Did you mean:
Regular Visitor

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 Slicer (values 0,1,2).

I would like to create a Slicer, based on this measure, so that I can filter based on (0,1,2). However, I cannot put the measure as slicer.

I uploaded the data to OneDrive as well, here is the link:

https://1drv.ms/u/s!Ah2VGOQRBzRVhi-vYXzSW8c8QdVA

Any help would be greatly appreciated!

Many thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

Re: Measure as Slicer - Workaround?

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.

3 REPLIES 3
Community Support Team

Re: Measure as Slicer - Workaround?

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"

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.

Regular Visitor

Re: Measure as Slicer - Workaround?

Hey @v-juanli-msft,

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,

Community Support Team

Re: Measure as Slicer - Workaround?

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.