Individual Measure Formatting within Calculation Group

DAX DAX Calculations
1

Hi All

My question takes a different angle but stems from a topic that already has a solution.

See link below:

Name of topic: Dynamic measure formatting in charts using Calculation Groups

Question:
How would you format say the Margin % column only if for example it had negative % values so that the negative % values are red and the positive values are green?

2

what you are looking for here, is a conditional format - if you do a search on the forum, you will find several responses covering this topic for a variety of needs.

Conditional format settings for a table or chart can be found in the visual format settings (image below is from the column table settings):

image

3

Thanks @Heather. I have already done a search but couldn’t find anything helpful specifically for this problem. If you know of specific post please may you share the link.

4

Hi @Harvey, you may also want to check this videos. You might get additional tips here.

2 Likes
5

Awesome! Thank you @Heather!