Sorting stacked bar chart by total not correct for calculated measure
PowerBI novice here. I have a measure named 'Measure_2' that displays this information where commodity( Electric, Natural Gas, Steam, etc) is the legend for stacked bar chart. This is the data in a tabular format. I would like to sort this by the total of all columns for individual Building. Basically keep the longest bar first. I have selected the sort by Measure 2 in descending order However this doesnt sort the stacked bar chart in the correct order even though the totals above each bar is correct. Is there a way to achieve this?
