Applying a parameter to a dynamic Y axis

[Anonymous]

I need help to apply a parameter on a dynamic Y axis of a bar chart. Let me explain:

1. I have created a calculated column with the Sales amount that is multiplied by  1-Parameter, something like:

 Calculated column = sum([Sales Amount]) * (1-[Myparameter])  --> ex: 400'000 * (1-[Myparameter])

2. Myparameter has been created in Power Bi desktop in the What if Scenario tab, as a numerical range from 0 to 1 with an increment of 0.1 --> formula:                     Myparameter= GENERATESERIES(0, 1, 0.1).

This parameter is like a percentage discount that I want to use in a Scenario analysis to see how the Sales Amount changes according to the percentage discount.

3. I would like to create a bar chart that displays on the Y axis the "Calculated column" grouped with bins size of 500. 

4. On the X axis I would like to have the Count Distinct per Client, so I want to see the Count of Clients per Sales bins. And the count of clients should be moving according to the parameter.  We should see the Count of Clients moving to other Sales bins when we change the parameter.

It should look like the following chart.

At the moment I am not able to apply the filter to the calculated column or the grouped calculated column with the bins. I was hopping to create a dynamic Scenario. Apparently the parameter only works on measures and NOT calculated column.

Please help me 🙂

[amitchandak · Accepted solution]

@Anonymous , I think what you need is dynamic segmentation on measure , something similar I done in these examples 

Single value

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

range

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

[Anonymous]

Hi Amitchandak,

Thanks a lot for the solution offered. The solution was in the first video you shared : Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

It was thanks to the max() argument that we managed to link the parameter calculation to the Y-axis.

I will definitely subscribe to your Youtube channel since you are an expert in PowerBi 😉

Cheers!