cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tenkes77 Regular Visitor
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,

 

Adam

 

Slicer_1.JPGSlicer_2.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Measure as Slicer - Workaround?

Hi @Tenkes77

Create the new table as below

2.png

create the measure

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

add measure in the visual level filter

1.png

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
Community Support Team

Re: Measure as Slicer - Workaround?

Hi @Tenkes77

workaround 1:

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

4.png

 

workaround 2:

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

6.png

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

5.png

 

 

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.

Highlighted
Tenkes77 Regular Visitor
Regular Visitor

Re: Measure as Slicer - Workaround?

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

 

Slicer_1.JPGSlicer_2.JPGSlicer_3.JPG

Community Support Team
Community Support Team

Re: Measure as Slicer - Workaround?

Hi @Tenkes77

Create the new table as below

2.png

create the measure

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

add measure in the visual level filter

1.png

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.