Forum Discussion
Creating Data Visualization sorted by combination of y-axis values
In the first step create measures for your segments (instead of just dragging and dropping the columns)
for example =Cross_Sales = sum('financials'[Cross sales])
After you have 3 measures of segments, you should summarize them with new Dax measure :
sum_segments = [Measure_11]+[Measure_12]+[Measure_13]than on X-Axis you need to put your categories :
on Y-Axis - 3 measures of segments.
on tooltip sum_segmentsResult you can sort your columns by Sum_measures or by separate segment according to your needs:
Example of sorting by segment:Example of sorting by sum_messures:
Sample linked file updated too: Link to the updated file
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Sorry, could you explain to me how to do that? You're saying to put all three y-values into a single y-value, but I don't really know how that works. I'm fairly new to Power BI.
In the first step create measures for your segments (instead of just dragging and dropping the columns)
for example =
Cross_Sales = sum('financials'[Cross sales])
After you have 3 measures of segments, you should summarize them with new Dax measure :
sum_segments = [Measure_11]+[Measure_12]+[Measure_13]
on Y-Axis - 3 measures of segments.
on tooltip sum_segments
Result you can sort your columns by Sum_measures or by separate segment according to your needs:
Example of sorting by segment:
Example of sorting by sum_messures:
Sample linked file updated too: Link to the updated file
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly