Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi, 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
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsthank you! Got the result 😄
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |