Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Applying a parameter to a dynamic Y axis

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 🙂

 

 

 

 

2 Replies