Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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!

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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