Dynamically set legend colors based on number of items selected

[cleslie]

I have a clustered bar chart displaying Average Dialy Visits (counts) by month (count on y axis, month on x axis) collected at a number of different locations. I have a slicer allowing the end use to select 1 or more locations (there are 45 locations in total). In order to facilitate comparaison of monthly visitation counts for different locations, I am using the locations as the categories for the "Legend" field.

Typically, the end use will only select a few locations at a time (let's say a max of 3). However, by default Power BI assigns a static color to each category. What I would like to do is assign the legend colors dynamically based on the number of locations selected. For example, if only one location is selected it is always green. If two are selected, one is green and one is blue. If a third is selected, green, blue and yellow. Etc.

It really doesn't matter which location is assigned which color when selected so that isn't a constraint.

[cleslie]

I have a clustered bar chart displaying Average Dialy Visits (counts) by month (count on y axis, month on x axis) collected at a number of different locations. I have a slicer allowing the end use to select 1 or more locations (there are 45 locations in total). In order to facilitate comparaison of monthly visitation counts for different locations, I am using the locations as the categories for the "Legend" field.

Typically, the end use will only select a few locations at a time (let's say a max of 3). However, by default Power BI assigns a static color to each category. What I would like to do is assign the legend colors dynamically based on the number of locations selected. For example, if only one location is selected it is always green. If two are selected, one is green and one is blue. If a third is selected, green, blue and yellow. Etc.

It really doesn't matter which location is assigned which color when selected so that isn't a constraint.

[Anonymous]

Hi @cleslie,

Nope, current power bi not support this.

In fact, condition formatting feature support to use other column value to setting color, but you can't create dynamic calculate column/table based on slicer/filter to make color fields dynamic.

BTW, you can create dynamic measure based on slicer/filter, but it can't use on legend and axis fields.

Regards,

Xiaoxin Sheng