Reply
Highlighted
Regular Visitor
Posts: 43
Registered: ‎08-30-2018
Accepted Solution

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


Accepted Solutions
Community Support Team
Posts: 2,773
Registered: ‎03-15-2018

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.

View solution in original post


All Replies
Community Support Team
Posts: 2,773
Registered: ‎03-15-2018

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.

Regular Visitor
Posts: 43
Registered: ‎08-30-2018

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
Posts: 2,773
Registered: ‎03-15-2018

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.