Forum Discussion

sdegroot's avatar
sdegroot
Helper I
9 years ago

Color coding based on changing baseline and target

Hello,    I'm trying to create a line and cluster column chart that changes colour when the baseline and the target are met. One colour below the baseline, one colour above the baseline and one col...
Need Help
prathy's avatar
prathy
Advocate III
9 years ago

Hi,

Kind of conditional formatting you are after; I don't think it is available out of the box. But, if you want you could probably add some custom columns and add overlays of charts to get something like below. NB: Works better only when you don’t want visuals to interact with other visuals on the report I don’t think, my idea is a best practice but a work around :)


If you wnat I will share my PBIX file, let me know!

HTH!

Prathy

sdegroot's avatar
sdegroot
Helper I
9 years ago

Hello Prathy,

Thanks for you response. I think we're looking for something a little more asthetically appealing so I've used the option of just using a column chart and using Diverging Data Colors. Unfortunately, because I have to state a minimmum and a maximum # it does not work well with the different fields as each field has a different baseline and target :(. Basically, here's what's happening now.

 

I properly set up one field indicator:

 

 

But the next one will look like this since the the color coding is not based on a field: