Skip to main content

Power BI

Needs Votes

Dynamic Distinct Data Colors

Vote (25) Share
Marek Matuszewski's profile image

Marek Matuszewski on 14 Sep 2017 23:09:00

Today, we can define Data Colors for different Categories in most of visuals (Legend). However we have to define one color for each category statically. Let us assume, that we have a visual, which is dynamically populated with TOP 5 Categories out of 100. Those TOP 5 Categories, can vary, depending on the User Filter selection. This leads to the confusion, that 2 Categories (out of 100) can receive the same color. The idea is, to select 5 colors for those 5 TOP categories, disregarding which category will be "selected/displayed" - but what is most important - ALWAYS DISTINCT COLORS.