Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello All, I new and spent about 45 minutes reading through previous treads not to ask the same question. Unfortunately, I could not find something that helpe me.
I am somewhat versed with Excel, but PBI is not excel ;). So, I am trying to do a conditional formatting to show the below:
This is in Excel
If the change Y-on-Y is UP = Green, DOWN = Red and UNCHANGED = None.
I tried it on PBI through rules, but was not successful.
This is how the fields look like.
Thank you all in advance - Regards, Vidal
Solved! Go to Solution.
Hi @vidalbra .
Do you have a Y-on-Y calculation on your model? You need to create one measure to do that calculation and then use it on the rules where if the Y-on-Y is higer than 0 lower than zero or equal to zero,
No need to place it on the Matrix except on the condittional formatting.
The YoY should be similar to this one:
Value YoY% =
VAR __PREV_YEAR = CALCULATE( [HeadCount Demand], DATEADD(Calendar[Date], -1, YEAR))
RETURN
[HeadCount Demand] - __PREV_YEAR
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @vidalbra .
Do you have a Y-on-Y calculation on your model? You need to create one measure to do that calculation and then use it on the rules where if the Y-on-Y is higer than 0 lower than zero or equal to zero,
No need to place it on the Matrix except on the condittional formatting.
The YoY should be similar to this one:
Value YoY% =
VAR __PREV_YEAR = CALCULATE( [HeadCount Demand], DATEADD(Calendar[Date], -1, YEAR))
RETURN
[HeadCount Demand] - __PREV_YEAR
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsAsk questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
118 | |
101 | |
76 | |
68 |