Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |