Conditional format negative percentages

DAX DAX Calculations
21

@suzanne,

This is a cool concept, and I would love to be proven wrong here but I don’t think it’s possible to fully automate this in the way you are requesting. I think to implement this type of logic based on measure name, you would need to use calculation groups. While you can dynamically format strings using this technique

https://www.sqlbi.com/articles/dynamic-format-strings-with-calculation-groups/

at this point you can’t apply font or background colors in the same way via tabular models:

https://github.com/otykier/TabularEditor/issues/545

However, I am early in the learning curve on calculation groups, so would be thrilled to have someone jump in here with an ingenious solution that proves me wrong…

– Brian

1 Like
22

I tried my hand at this several ways as well, and have not found a way to do it. That being said, I’ll keep this in the back of my head, and if I hear of (or stumble into) any potential solution, I’ll circle back.

I have almost no experience with calculation groups - so I can’t add anything to what @BrianJ has said .

23

Hi @suzanne , did the response provided by the experts help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!