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.
Hello All,
I have been using the below to format values in a matrix. It works well except for null values I have in my table. I've tried a few things without success. Am I a firstnonblank somewhere away from making this work?
Solved! Go to Solution.
Hi @PBI_Rookie ,
Sorry for replying late. Did the blank value not show in the matrix? If so, you need to create a seprate table for this column, create relationships between them and create a measure to + 0 to show:
Table = DISTINCT('Specifications'[V])
Measure = SUM('Table'[V]) + 0
Now the conditonal format rule should work:
Attached a sample file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
I tried what you suggested. I made one change from UpperLimitCheck to Lowerlimit check as that is where the null values are(in red). I'm still seeing the same issue as before with flagging a null table value. Did I miss something in your suggestion?
Thank you
Hi @PBI_Rookie ,
Sorry for replying late. Did the blank value not show in the matrix? If so, you need to create a seprate table for this column, create relationships between them and create a measure to + 0 to show:
Table = DISTINCT('Specifications'[V])
Measure = SUM('Table'[V]) + 0
Now the conditonal format rule should work:
Attached a sample file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@PBI_Rookie , Also add condition for blank
IF(LowerLimitCheck >0, "#f25a38",
Switch( True() ,
isblank(UpperLimitCheck) , "#04bf9d"
UpperLimitCheck >0, "#f25a38", "#04bf9d"))
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |