I have Profit% ranging from 0.0 to 200.00%, and I want to display in Slide with min(profit%) and max(profit%) as a slide variable and able to display in chart or KPI avg(profit%) based on min(Profit%) and Max(Profit%) variables. can you please help on this.
I am using Range Slider, I am able to show vMin(profit%) and vMsax(profit%) values from database, but based on min and max slider selection I want able to display listing of min and max avg(Profit%) details. I am attaching screen shot and sample data.
You have to create a measure accordingly which will respond to your slider.For eg. if you want your profit should be as a percentage of sales (eg. 20% of sales) then first crate a variable "percentage" with min value and max value.
After this you create a measure with an expression using the variable created.
So in the above example your measure will be ([Sales]*[percentage]) and apply.