Allow user to control variable value inside measure from textbox?

[Anonymous]

Hi, 

I suspect this is impossible but worth a shot, or maybe worth doing another way. Let's say I have a column of decimal numbers, and another column of date, and I am plotting the median values of that column over time on a bar chart (ie what is the median on different days). 

However, what if the user wants to see a different percentile, ie the 90th percentile of the data, in addition to the 50th percentile? Right now I have duplicated my bar charts and created bookmarks labelled median, 90th percentile which shows/hides the relevant graphs. 

What I would like is to have a textbox that allows the user to type in say "50" and it would show the median, or "90" and it would show the 90th percentile. Is this functionality supported?

[Anonymous · Accepted solution]

if you want to accept input from user then you need to create dummy table with required values.

In your case you want to show 50 & 90 percentile.

Let's say in your may be they want to see others percentile as well.

SImply create table and add 10 ,20,30,... 100 values in it.

User can select these values from slicers.

ANd you need to create measure which calculates median automatically based on slicer selection that is SELECTEDVALUE().

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.