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 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

 

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.

4 Replies

  • 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

  • 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