Conditional Format Column Chart Labels

DAX DAX Calculations
1

Hi
I’ve looked at similar threads but can’t see what I’m looking for.

Ok. I have a column chart with conditional formatting on the bars for different states (groupings). All well and good.

What is NOT working for me is conditional format of the labels. Basically when NO year is selected I don’t want the labels to show (ie white). When a year is selected, OK.

Now the chart has %age labels and when no year is selected, the measure shows more than 100% because it’s the sum of the same score for all years. ie it shows 300% or 256% or whatever. I don’t want that, so I thought conditional formatting using saying "if greater than 0, “white” if less than or equal to 1 black. But it ain’t working for me.

Here’s an image.

power bi conditional format label not working
power bi conditional format label not working1273×322 64.5 KB

Any thoughts. This has to be simple!

2

Sorry the image with the colors is fine… I want the labels because a year is selected and the color coding shows the banding. But the top one… ie no color… I don’t want the labels because that’s all years and the %age is meaningless.

3

from your description, I’m guessing something like this will work?

image

image
image728×481 8.65 KB

for my simple example file, I used the following measure to format the text color of the different lables.

Conditional Color = 
VAR _Black = "#60505C"
VAR _Transparent = "#00000000"
RETURN
    IF( ISFILTERED('Table'[YEAR] ), 
        _Transparent, 
        _Black )

file is attached
eDNA Solution - Conditional Color on Column Chart.pbix (18.2 KB)

4

Hello @Ericadyson, just following up if the response from @Heather help you solve your inquiry?

We’ve noticed that no response has been received from you since November 14. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

5

Hi Heather… didn’t see your reply until EDNA sent me a trigger reminder. So thanks. Actually it’s the other way around… but yes, that’s great. Thanks so much. I actually had a version where no chart showed if no years were selected and then they appeared with the correct formatting for the bars depending on the values. But this is also good. Mega thanks. A simple one, but for lesser mortals, help is always needed!

1 Like
6

always happy to help @Ericadyson , and I’m glad the example file gave you the info you needed :slight_smile:

it’s the little tricks like this that can raise a report from ‘okay’ to “Wow!”