Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Slicer Using Measure Based on Criteria

Hi,

 

Is it possible for a slicer to accommodate a measure based on criteria e.g. the screenshot showed criteria for Negative Variance, Negative Variance with No Sales, etc?

 

//NT

 

 

 

Need Help

8 Replies

  • hnguy71's avatar
    hnguy71
    Super User
    2 years ago

    Hi Anonymous ,

    Assuming that the comments within your measure are derived by a logic, yes.

     

    Let's assume you have a comment measure with something similar to this:

     

    You'll need to create a disconnected slicer table that holds the same value. For example:

     

    Next, you'll create a measure to determine which row you should keep:

     

    Finally, add a filter on your table by filtering the measure for the value of 1.


    To see it in action:

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Do I need to create a separate table in the power query as the initial step?

      • hnguy71's avatar
        hnguy71
        Super User
        2 years ago

        Hi Anonymous , 
        A separate disconnected table, yes, but it doesn't need to be creaetd in power query if you don't feel like it. You can select "New Table" and use the DATATABLE function to create your table: