**BUG** Measures that return strings no longer useable for conditional formatting

[arpost]

When creating field value conditional formatting, Power BI no longer accepts measures that evaluate to strings. This hasn't been the case but apparently changed in an update or with a feature at some point.

BUG BEHAVIOR

For example, let's say I have a measure called Red that contains a string as follows:

Red = "#CF000F"

I then have a formatting measure that references that measure:

SlicerTitle = [Red]

The SlicerTitle measure can now no longer be added to Field Value conditional formatting:

ODD BEHAVIOR

However, visuals that had this measure added successfully in the past still work. Additionally, it starts working if I:

1. Change the [SlicerTitle] reference to the [Red] measure to an explicit color string (i.e., SlicerTitle = "#CF000F").
2. Add the measure as field value formatting to a visual (PBI accepts this because strings are explicitly written).
3. Add the reference to the [Red] measure back in after adding to visual (i.e., change SlicerTitle = "#CF000F" back to SlicerTitle = [Red]).

REALLY hope this gets fixed as it is incredibly frustrating to have to do workarounds.

[Anonymous]

Hi @arpost ,

I am unable to reproduce your question.

This is my Desktop version:

 

It's working fine. Please update Power BI Desktop to the latest version.

Best Regards,
Community Support Team _ Neeko

[arpost]

Greetings, @Anonymous. Appreciate the reply. I downloaded the latest version (2.121.662.0 64-bit) but am still experiencing this behavior. I'm using the Microsoft Store version.

Out of curiosity, can you try to add your SlicerTitle measure as conditional formatting to a slicer header's font color?

[arpost]

Update: @Anonymous, this looks to be caused by the use of calculations groups in the report. I tested the same measure approach in a report not using calc. groups and had no issue; when I added a calc. group to the report, it stopped working.

Which doesn't make any sense since these measures are explicit strings. I know calc. groups discourage implicit measures, but these measures should work for conditional formatting. Plus, they do work already for other visuals in the report; I just can't use the measures to format new visuals. Can this get fixed?

[arpost]

Any update, @Anonymous?