Order a chart by a sum of a category in the legend

[menezesan]

Hello, 

I need to order my Stacked column chart by the sum of a category in a field and not the count of lines.

For example:

I do have 139 issues for GM being 2 of them as red impact

and I have 114 for Risk, being 8 as red impact

I need the Risk group be the first one in the chart instead of the GM.

Someone knows how to help?

[kpost · Accepted solution]

Sounds like you just want to sort it by the sum of "Red".  You'll notice my legend is not sorted the ways yours is, but this should still work for you.

See attached .pbix file for an implemented solution.

Create a measure like this:

Red = calculate(COALESCE(SUM('Table'[Value]), 0), 'Table'[Impact] = "Red")

Add it as a 'Tooltip' value

Then sort the visual by that measure, descending.

 

A potentially unwanted side effect is that when you hover on a column, the measure value "Red" value will show up.

 

///Mediocre Power BI Advice, but it's free///