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.
Solved! Go to Solution.
Conditional formatting is a feature of the visual, not the measure. If your measure is displayed in a table or matrix, take a look at this link for additional information.
Apply conditional table formatting in Power BI - Power BI | Microsoft Docs
Hi @PBI-Curious
I've created a basic example below:
Sum = SUM('Values'[Value]) + 0
This first code would essentially be your Net Timing 2 function.
Create a second function using the following code:
Colour =
VAR _SUM = SUM('Values'[Value])
VAR _Colour = IF(_SUM < 0, "#DB271C", "#73B761")
return _Colour
Replacing the _SUM code with your first function code again.
Now in your visual click on the drop down where your first measure is located and select conditonal formatting.
Select background colour -> Change the format style to field value -> Select your colour measure and hit ok.
Any tile with a negative number will now appear red and any non negative numbers will be green.
Hi @PBI-Curious
I've created a basic example below:
Sum = SUM('Values'[Value]) + 0
This first code would essentially be your Net Timing 2 function.
Create a second function using the following code:
Colour =
VAR _SUM = SUM('Values'[Value])
VAR _Colour = IF(_SUM < 0, "#DB271C", "#73B761")
return _Colour
Replacing the _SUM code with your first function code again.
Now in your visual click on the drop down where your first measure is located and select conditonal formatting.
Select background colour -> Change the format style to field value -> Select your colour measure and hit ok.
Any tile with a negative number will now appear red and any non negative numbers will be green.
Conditional formatting is a feature of the visual, not the measure. If your measure is displayed in a table or matrix, take a look at this link for additional information.
Apply conditional table formatting in Power BI - Power BI | Microsoft Docs
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |