Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Slicer Slider With Average Values.

Hello,

 

Does anyone knows how to change the value releflected in the slicer slider/between to be base on average values  and not the  min and max of the value data?

 

For example my data max percentage is 876.62%, since it was an average of the values and in the slider is showing 20000%, base on the max value of the individual row data. I already try multiple DAX formulas in the slider value but none are working.

 

Any help will be much appreciated.

 

 

 

 

Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    7 years ago
    Spoiler
     

    Anonymous  you probably already know that you cannot use measure as slicer. One way you can do it is to create a table using DAX from your average value and then use that table for slicer and to filter your dataset.

     

    It is bit of work but can be achieved.

     

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    7 years ago
    Spoiler
     

    Anonymous  you probably already know that you cannot use measure as slicer. One way you can do it is to create a table using DAX from your average value and then use that table for slicer and to filter your dataset.

     

    It is bit of work but can be achieved.