Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Kimber
Helper II
Helper II

Complex conditional formatting stopped working

Up until today, I've been using a field to conditionally format the callouts on card visuals. All of a sudden, although the formatting is still being applied correctly, I can't see the name of the field in the selection box. When I select the field from the dropdown, the dropdown goes blank immediately again. Even worse, I can't apply this field to conditionally format NEW visuals. 

Kimber_0-1739400824979.png

I haven't changed the definition of the field:

3rd Grade STAR On Track_Trend Color =

SWITCH (
    TRUE()
    ,'DataView STAR_StateReadingEnglish_Current'[Change in % 3rd Grade On Level as number] >= 'Style Elements'[Threshold Up]
        ,  'Style Elements'[Positive Color]
    ,'DataView STAR_StateReadingEnglish_Current'[Change in % 3rd Grade On Level as number] > 'Style Elements'[Threshold Static Upper Rng]
        , 'Style Elements'[Trending Positive Color]          
    ,'DataView STAR_StateReadingEnglish_Current'[Change in % 3rd Grade On Level as number] >= 'Style Elements'[Threshold Static Lower Rng] && 'DataView STAR_StateReadingEnglish_Current'[Change in % 3rd Grade On Level as number] <= 'Style Elements'[Threshold Static Upper Rng]
        , 'Style Elements'[Neutral Color]  
    ,'DataView STAR_StateReadingEnglish_Current'[Change in % 3rd Grade On Level as number] > 'Style Elements'[Threshold  Down]
        , 'Style Elements'[Trending Negative Color]
    ,'DataView STAR_StateReadingEnglish_Current'[Change in % 3rd Grade On Level as number] <= 'Style Elements'[Threshold  Down]  
        , 'Style Elements'[Negative Color]
    ,"#000000"
)

I've verified that the field returns a valid Hex color: 

Kimber_1-1739401267106.png
I've also verified that all of the other fields referenced in my 3rd Grade STAR On Track_Trend Color return valid data.
 
Does anyone have any idea what could be going on here?
1 REPLY 1
Kimber
Helper II
Helper II

I've narrowed it down. The problem is introduced when I reference 'Style Elements'[Positive Color] (or any of the other color fields). Here's the definition of [Positive Color]: 

Kimber_0-1739402639834.png

If I paste the hex value into the formatting field, it functions as expected. It's just the reference that makes it stop being able to be selected.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.