Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to break this down to the most simplest form of conditional formatting, so I'm struggling to understand if it's intended to work the way I have in my head. Let's say I have a table such as the following:
Price1 Price2 %Diff
100 50 -50%
When using a standard table, all I'm trying to do is have the font color of the values in the %Diff column to display in red when it's a negative value. Seems like no matter what kind of rule or color scale option I try, I can't seem to pull it off! I know it has to be something that's obvious to everyone else, but reading other posts and watching videos I can't seem to apply that same logic to my simple needs. If anyone has any suggestions please help 🙂
Thanks!
Hi @Anonymous,
I'm not running into similar issues. Are your rules set up like below?
I just spotted in another thread that the conditional formatting won't work if your table only contains values. Is this true and why you had to add that attribute field?? I don't want/need any text in my table.
@Anonymous,
If you have no attributes, your measures will be a table with only a single row. If the %Diff only needs to be seen as an aggregate value, I would recommend showing the values in cards as a high-level KPI.
Could you expand on what you're trying to display, and how?