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.
I have created a measure that calculates the Year on Year % Growth of Revenue. I have formatted the measure as percentage.
I am trying to have conditional formating where if it is a positive number, it is highlighted in green and red if it is negative. However, I am just not finding the dropdown option of "Percentage" and "Number"
I tried to alternate by of formatting by field value instead of rule, however there is no option within the field value dropdown.
Please help. Thanks
Solved! Go to Solution.
Hi @alvinyong ,
You can create a measure as below for the setting of backgroud color first:
Background color = IF([YoY YTD Revenue Growth %]<0,"Red","Green")
Then set the conditional formatting for the measure "YoY YTD Revenue Growth %" just like the one in below screen shot:
Best Regards
Rena
Hi @alvinyong ,
You can create a measure as below for the setting of backgroud color first:
Background color = IF([YoY YTD Revenue Growth %]<0,"Red","Green")
Then set the conditional formatting for the measure "YoY YTD Revenue Growth %" just like the one in below screen shot:
Best Regards
Rena
@alvinyong , You can create a colo measure and use it
Example. : Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
In this UI use the field in the first option and use this kind of measure
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
67 | |
63 |
User | Count |
---|---|
213 | |
124 | |
117 | |
81 | |
75 |