Adding aggregation option to Y Axis via Slicer

[Anonymous]

I'm working on a report and would like to show my values on average and on median between three charts. Right now I need to toggle each three charts one by one from one aggregation to another. Is there a way to add this option to a slicer? When I add the field to the slicer, it just gives me numerical range of values.

[Anonymous]

Worked like a charm, thank you!!

[Ritaf1983]

Happy to help 🙂

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
Yes, you can create the 3 needed measures with Dax and use field parameters to select the wanted measure to show.

Please refer to the linked tutorial:

https://www.youtube.com/watch?v=V6WchPDZibI

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.