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-does-nothing/td-p/98919/highlight...
Solved! Go to Solution.
Hi @OneWithQuestion,
The Concatenate Labels does work with combo charts and ribbon charts.
Please ensure the chart sort by x axis values. You can also see Amanda's reply here: http://community.powerbi.com/t5/Desktop/concatenate-x-axis-does-not-work-for-all-char-types/td-p/100...
Please run teh latest Power BI desktop version 2.58.5103.501.
Best Regards,
Qiuyun Yu
Hi @OneWithQuestion,
The Concatenate Labels does work with combo charts and ribbon charts.
Please ensure the chart sort by x axis values. You can also see Amanda's reply here: http://community.powerbi.com/t5/Desktop/concatenate-x-axis-does-not-work-for-all-char-types/td-p/100...
Please run teh latest Power BI desktop version 2.58.5103.501.
Best Regards,
Qiuyun Yu
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.
Thanks @Amanda for the initial solution, appreciate the help!
@v-qiuyu-msft Is there a solution for if I want to keep the x-axis sorted by a different metric? This works initially when I sort the x-axis alphabetically, but then when I re-sort by a different metric (e.g. total sales), the concatenate labels option turns back on. This seems like a pretty glaring shortcoming to me.
Another thread experiencing the same issue https://community.powerbi.com/t5/Desktop/Disable-concatenate-x-axis-is-not-working-in-April-version-...
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
73 | |
69 | |
47 | |
47 |
User | Count |
---|---|
161 | |
85 | |
76 | |
68 | |
67 |