Percentage change based on a time value on a sliding scale?!

[64653463456greg]

I have a problem I’d love to get some help on.

So, I have a bunch of percentages based on serial numbers (see pictures).

These percentages change based on a time value in minutes. It's a bunch of sessions between 1 and 600 minutes and the percentages are how many of the sessions are under a certain time value.

The picture is how the percentages look at the 40-minute mark and the 50-minute mark.

What I’d like to try and do is make a sliding scale where the percentages change when I change the time variable.

So that it goes from how it looks in the first picture at 40 minutes to how it looks in the second picture at 50 minutes but in a continuous fashion on something like a slider based on the minutes.

Is this something that can be done? 🤔

Any help I can get in doing it would be greatly appreciated.

40 Min

50 Min

[Anonymous]

Hi @64653463456greg ,

Please check if what-if parameter is what you want, you can refer the following links to implement your requirement.

Passing between parameters to a measure using Whatif Analysis

Avg Selling Price Filtered Range =
VAR av_price = [Avg Selling Price (Billed) Monthly]
RETURN
    CALCULATE (
        [Avg Selling Price (Billed) Monthly],
        FILTER (
            Table,
            av_price >= MIN ( Parameter[Parameter] )
                && av_price <= MAX ( Parameter[Parameter] )
        )
    )

Getting Started With The “What If” Parameter In Power BI

If the above one can't help you get the desired result, please share some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards