Using relative/dynamic values in conditional formatting of data colours in shape map

[Anonymous]

Hello,

Is there any way to add relative values in the data colours parameters, rather than just absolute values?

When I add filters to reduce the sampled data, the absolute middle value I use is no longer an appropriate value to use to provide a useful range of colours to spot differentiation between regions.

Is there a way to use a median as the middle value, so that the colour dynamically changes to different filters used?

Thanks!

[Anonymous]

Hi @Anonymous,

Base on my research, currently there is no function or option which can set dynamic value for the option "Center" of the shape map. You can raise a new idea and add your comments there to make this feature coming sooner. And the following one is one similar idea shared on Power BI Ideas, you can vote it up and add your comments there to improve Power BI on this feature.

dynamic max color for shape map

Best Regards