Forum Discussion
Helper IVActual vs Expected
I want to show Actual vs Expected but with accepted variance.
For eg: If my Expected is 10, the user entered a value 2, if my actual is 8 or 12 then actual will be in green otherwise red.
Hi Ethanhunt123 ,
We can create the measure and set conditional formatting based on it.
Measure = VAR p = SELECTEDVALUE ( Enter[Value] ) + SELECTEDVALUE ( Expected[Value] ) VAR m = SELECTEDVALUE ( Expected[Value] ) - SELECTEDVALUE ( Enter[Value] ) RETURN IF ( MAX ( actual[Value] ) = p || MAX ( actual[Value] ) = m, "#00FF41", "#FF0006" )For more details, please check the pbix as attached.
2 Replies
v-frfei-msftCommunity Support
Hi Ethanhunt123 ,
We can create the measure and set conditional formatting based on it.
Measure = VAR p = SELECTEDVALUE ( Enter[Value] ) + SELECTEDVALUE ( Expected[Value] ) VAR m = SELECTEDVALUE ( Expected[Value] ) - SELECTEDVALUE ( Enter[Value] ) RETURN IF ( MAX ( actual[Value] ) = p || MAX ( actual[Value] ) = m, "#00FF41", "#FF0006" )For more details, please check the pbix as attached.
- amitchandak
Super User
Not Sure. But are looking for what if. Refer
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
https://www.absentdata.com/power-bi/parameter-power-bi/
In not. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
ThanksAppreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
