Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
8 years ago
Solved

concatenate Labels does not work properly

When using concatenate labels on combo charts or ribbon charts, it does not work properly.   This thread has details on the issue: https://community.powerbi.com/t5/Service/Concatenate-Labels-option...
Reports
ryan0585's avatar
ryan0585
Advocate II
5 years ago

For posterity on this thread, this might be "solved" but it's still probably a bug.  I'd expect the behavior to be when I disable "Concatenate labels" I'd see the hierarchical grouping take effect on the x-axis of my chart.  It does not though, at least not immediately.

To get it to take effect, I have to sort as v-qiuyu-msft mentioned above, but in my case since my chart was already sorted the way I wanted, I had to re-sort it.

It would be great if an already sorted chart (i.e. by the labels on the x-axis) would have the concatenation removed automatically without having to re-sort.  Suffice to say, if you re-sort the chart by your x-axis label, the concatenation removal/grouping will take effect.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

This result is the actual answer, the only thing that fixed this bug for me was to change the sort from being the x-axis and then change it back to being the x-axis and then this fixes the problem.