Forum Discussion
Anonymous
3 years agoNot applicable
Creating Data Visualization sorted by combination of y-axis values
I currently have a stacked column chart with three aggregate values in the y-axis. Is it possible for me to sort by the combination of all three of these values? Currently, the sorting options only s...
- 3 years ago
Hi Anonymous
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
Ritaf1983
Super User
3 years agoHi Anonymous
Please show some example of your data and desired result