Grouping and sorting of bar chart

[Anonymous]

Hi,

I have the following chart:

 - X-axis: simple Countrows Measure.

 - Y-axis: Departments

 - Legend: Column: Site 

The chart is sorted by descending values of the Measure.

Is there a way to group the bars by site? so showing from the top the blue bars first in descending order, and then the green bars in descending order below that.

I don't want to use datagroups because the incoming data might change.

Help is much appreciated 😄

grts,

[amitchandak]

@Anonymous , On in Bar , but you can do that in column bar

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

But I think you should be able to apply conditional formatting even on Bar(horizontal) without using Concatenate Label

use a measure like

Switch(Max(Table[Site]) ,

"Site 1", "Blue",

"Site 2", "Green",

// add other

"red"

)

USe this in conditional formatting using field value option

[Anonymous]

Ok, I have done this: Added "Site" to the Y-axis, expanded down in the hierarchy and conditionally formatted using the color-Measure.  Now I can sort the visual by site, so the green bars and blue bars are grouped. But the departments are now sorted alphabetically and not by the value of the Count-measure. Is it possible to have a secondary sort on the visual?