Hi Team, I have to created a Column chart using the following item locations amount, time period X axis =time period, Y axis = Amount, Legend =locations I have a stacked Column chart displaying Amount by time period ( Amount on y axis, time period on x axis) collected at a number of different locations.. In order to facilitate comparaison of time pweriod visitation amount for different locations, I am using the locations as the categories for the "Legend" field Typically, the end user 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 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. Regards Arjun V
v-xiaoyan-msft
on:
"Sort by column" should work regardless of key col...