Forum Discussion

C_R's avatar
C_R
Frequent Visitor
2 years ago
Solved

Conditional formatting for date slicers conditionally broken

Hello everyone,
I have a strange behaviour with two slicers.

 

First, I created a table for a light and a dark theme. In it, one row is for the light theme and the other row is for the dark theme. I have stored different colour values (hex codes) in the columns. I now select the theme using a slicer. I use measures to determine the colour value that is to be used for the slicer title, for example.

Simplified example:

  • If I choose the dark theme, I use #FFFFFF.
  • If I choose the light theme, use #000000.

For the colour value changes I use a simple measure: MAX([column name]). I use the measure as a field value in the conditional formatting for titles (and other elements). This works fine if I have a dropdown slicer. But if I change the slicer to "between", then suddenly it no longer works. On the slicer where I change the theme, it doesn't work at all.

 

Here are two screenshots. One of the light and one of the dark theme.
In the middle is the colour code in the corresponding colour and the selected theme. On the left side are the calender-slicers that work. The colours of the titles change. On the right are the slicers that do not work. The 'broken' slicers always seem to use the colour from the dark theme. I don't understand why this is.

 

Am I doing something wrong, is this behaviour intentional or is this actually a bug in PBI Desktop?

 

Best regards,
C_R

4 Replies