DAX measure for the column/pie/ charts to color only the max value bar/slice

[preacher_baby]

Basically title. Say I have a bar / column chart with the maximum count of category having 5, while others have lower. I want this particular bar to be color with specific color, while other bars should have the same color.

[Anonymous]

Hi @preacher_baby ,

Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[ChiragGarg2512]

@preacher_baby , need to create a DAX measure using switch statement. In switch statement first parameter is values(column with category name), and the expression will be a dax that gives the name of category with highest count, value if this condition is true is the color wanted for top category and next is the color wated for remaining categories.

The expression will be made using index function.

Color top 1 = SWITCH(values('TableName'[category]),

maxx(INDEX(1,ALLSELECTED('TableName'[category]),ORDERBY([category count],DESC)), [category]), "Green",

"blue")

Change color as per convenience. Category count is a measure that with dax count('TableName'[category]).

If the category column is sorted by any numerical value include that column in ALLSELECTED.

Thank You.