Anonymous's avatar
Anonymous
Not applicable
7 years ago
Status:
New

Data Bars do not theme - Bug

Hi All,

 

I have been working with themes recently. My problem is I am trying to theme databars and having no luck...

Was hoping someone had a creative solution as I beleive I am hitting the limits of Power bi. Screenshots to follow

 

Most visuals let you set the data color to a color from the theme pallete.

  

Lets say I pick Orange.

I then can pass in a different theme and the color(green) in the same position in the new theme as my selected color (orange) will replace my previously selected color. as show in the image below

 

 

 

 

 

 

 

 

 

 

 

 

This same thing does not hold true to Data Bars. I can do the same exercise as above and it will keep my originally selected orange when switching themes. 

 

Other conditional formatting options(font color, background color) let you use a measure to color, Data bars do not. We use this report with different themes at multiple customers. So for now we will have to live without data bars.

 

Hoping someone has a workaround. 

 

Thanks

7 Comments

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support

    Hi Anonymous, 

     

    Which "Data Bars" do you mean? Please clarify it with detail information. 

    Which theme do you use, built-in theme or imported .json theme? 

     

    Best Regards,
    Qiuyun Yu 

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Goodmorning v-qiuyu-msft .The Data Bars I am speaking of are one of the default conditional formatting options for Tables and Matrices. 

      

     

    I am trying to use a custom theme. However, this morning I verifed that even if I use a built in theme the data bars do not change colors with the theme.

  • This sure seems like a bug to me and not a case of something being unsupported.  It clearly lets you select a color from the theme palette, but doesn't apply when you change the theme.  Can someone at Microsoft please confirm the intended behavior is occuring?

  • Anonymous's avatar
    Anonymous
    Not applicable

    v-qiuyu-msft  Hi, has there been any progress made on this issue? The idea you linked me to has been implimented. There is a bug when switching between themes. I would be happy to hop on a call and demo the issue for a dev.

     

    Thanks

  • 4 years later, the problem has still not been solved. At least Microsoft has introduced the PBIR format. Great progress, even if still a preview feature. The problem is easy to recognize here. Instead of the first setting, the second should be allowed. Currently supported: "positiveColor": { "solid": { "color": { "expr": { "Literal": { "Value": "'#F4AFEE'" } } } } }, Needed: "positiveColor": { "solid": { "color": { "expr": { "ThemeDataColor": { "ColorId": 2, "Percent": 0 } } } }