How to get a measure from a parameter

[GwenLC]

Hi, 

I used scatter plots with dynamic axis using field parameters. I would like to set the maximum of the x-axis to the 99.5 quantile of the column I'm representing in the x-axis. How can I do that ?

[Mikelytics · Accepted solution]

Hi @GwenLC ,

in the scatter chart you can define the maximum of each axis using a measure

On Top the following function should help you to build the measure

PERCENTILE.EXC-Funktion (DAX) - DAX | Microsoft Learn

Best regards

Michael

-----------------------------------------------------

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

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn