Data Bars do not theme - Bug

[Anonymous]

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

[v-qiuyu-msft]

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]

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.

[Anonymous]

@v-qiuyu-msft  Any update on if this will be supported ?

[v-qiuyu-msft]

Hi @Anonymous, 

Based on my research, it's not supported to use custom theme to change conditional formatting color. Please vote on this same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140475-custom-theme-colors-for-conditional-formatting-dia

Best Regards,
Qiuyun Yu

[t-val79]

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]

@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

[martinr18]

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 } } } }