Using percentage slider to show the changes in a column

[Anonymous]

Hi,

Lets say i have the following information:

	Revenue	Cost	Net Profit
Jan-20	100000	50000	50000
Feb-20	2000000	50000	1950000
Mar-20	2000000	50000	1950000
Apr-20	2000000	50000	1950000
May-20	2000000	50000	1950000
Jun-20	2000000	50000	1950000
Jul-20	2000000	50000	1950000
Aug-20	2000000	50000	1950000
Sep-20	2000000	50000	1950000
Oct-20	3000000	50000	2950000
Nov-20	3000000	50000	2950000
Dec-20	3000000	50000	2950000
Jan-21	3000000	1000000	2000000
Feb-21	3000000	1000000	2000000
Mar-21	3000000	1000000	2000000
Apr-21	3000000	1000000	2000000
May-21	4000000	1000000	3000000
Jun-21	4000000	1000000	3000000
Jul-21	4000000	1000000	3000000
Aug-21	4000000	1000000	3000000
Sep-21	4000000	1000000	3000000
Oct-21	4000000	1000000	3000000
Nov-21	4000000	1000000	3000000
Dec-21	4000000	1000000	3000000

Now i want to have a slider where i can change the forecast revenue as a percentage, so i can show the impact on the net profit as a line chart?

For example, I want to see the net profit if i increase the revenue 5% or decrease 5%?

Is there something i can find on power bi?

Thanks in advance.  

[MFelix · Accepted solution]

Hi @Anonymous ,

You need to create a what if parameter.

Go to the modeling -> New parameter

Choose options:

Minimum: -1

Maximium: 1

Increment: 0.05 (to have 5% increase)

Then make the following measure:

Net_Value_Forecast = SUM('Table'[Net Profit]) *( 1+'Increase percentage'[Increase percentage Value])

check PBIX file attach.

[Anonymous]

Hi, thank you very much for your answer and especially for the file.

I think i am half way there. However, in this case the measure is changing according to the percertage but the net profit is remaining costent. I want all the rows to be updated along with the percentage. 

For example: How much increase by 5% will affect the measure along with net profit?

Thanks

[MFelix]

Hi @Anonymous ,

The  measure is the value you should use has you new net profit. If you look at the table I have place the second value gives you net profit + the 5% On March you have 1.950.000 * 105% = 2.047.500

Or do you just want the increase value?

In that case calculate  without the 1+ part of the measure

[Anonymous]

thank you! Got the result 😄

[amitchandak]

Refer:https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/

Other way is to use whatif parameters

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Assume percent measure is measure 1 and what slicer has a name slicer1

Filter % =

var _max = maxx(slicer1 ,slicer1[slicer1])

var _min = minx(slicer1 ,slicer1[slicer1])

Return

calculate(count(table[A]),filter(Table,[Measure] >=_min && [Measure]<=_max),values(table[ID])