Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Filters

For example, I have a column A with numbers, and I want to calculate +/- X% of Column A. I would like two have two slicers one as a drop for X% (5%, 10%, 15%, etc) and another slicer which will give ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Are you saying that if i select 5% in slicer it will returen both value * (1+5%) and value * (1-5%), if i select 10% in slicer it will returen both value * (1+10%) and value * (1-10%)?

If so you could create a table and measures as below.

Measure = SELECTEDVALUE('Table'[A])*(1+SELECTEDVALUE(slicer[+%]))

Measure 2 = SELECTEDVALUE('Table'[A])*(1+SELECTEDVALUE(slicer[-%]))

 

Result would be shown as below.

If i misunderstood your meaning, please show more details.

 

Best Regards,

Jay

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous so I did create a table to show something similar to what you have done. Let's say I have a KeyID associated for every record in that table, so I want to first select a single KeyID and when  I do that I want a Slicer that can represent  lower bound (Measure) and the upper bound (Measure 2)

 

 

Something like this

 
 

For now, the slicer is not Dynamic, it just gets the Max and Min value of Column A. Would be nice to have it dynamic.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago