Highlight minimum value in column chart dependent on multiple selection/slicers

[Kristan]

Hi all,

I want to highlight the lowest/minimum bar in a column chart that is being generated off muiltple slicers, thus the lowest value is constantly changing. I want all the other columns to remain the same colour and not change.

Does anyone know how I can do this?

Thank you

[v-yuta-msft]

Hi Kristan,

You can try conditional formatting and check if it can meet your requirement. If you have some special requirement, please clarify more details or show a demo.

Regards,

Jimmy Tao

[Kristan]

Hi Jimmy,

I have tried conditional formatting, that is specifying color by rules, but because the minimum value is not fixed but dependent on what is selected in the slicers I can't quantify what the value range should be.

I had added example

[v-yuta-msft · Accepted solution]

Hi Kristan,

I would recommend you to use color saturation, drag fare column to color saturation field.

 

PBIX: https://www.dropbox.com/s/oyhj3lk9g78ib3n/Highlight%20minimum%20value.pbix?dl=0.

Regards,

Jimmy Tao