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,
I have a report with a table where I need to highlight some values based on another field. The conditional formatting works as expected until I add another column to the table, then the conditional formatting is not being applied to values without a values in the new column.
I need to highlight (text in red) the sizes that are unavailable. Both XX-Large and XX-Small are highlighted as I want in the left table. When I add the count of sales to the table, the XX-Small is still red, but XX-Large, which has no sales, loses its conditional formatting.
How can I make it stay red?
My report is available here: https://www.dropbox.com/scl/fi/kaehipx737w9528mh8cy9/Conditional-formatting.pbix?rlkey=x31ivvj3450rj...
Thank you!
Solved! Go to Solution.
I tried at my end and I would suggest you to create a measure of Count of Sales and utilize it in the table that will resolve your issues.
I tried at my end and I would suggest you to create a measure of Count of Sales and utilize it in the table that will resolve your issues.
Thanks for the quick reply, it worked!
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |