Forum Discussion
concatenate x axis
Hi.
Last week, I disabled the concatenate option in the X axis in an histogram and it worked perfectly.
Now, I have downloaded Power Bi again to have the new features, but this option does not work any more.
Anyone can have an idea of what happened? and how can I fix this?
Thanks
I’ve got response from the Product Team.
This is due to a default sort that gets applied in one of the creation paths. You must have no sort (which causes an implicit sort correctly), or sort by the x-axis ascending. We are working on adding a warning for this. Please click the "..." on the visual container, and click the bold column name to remove the sort.
Best Regards,
Herbert
3 Replies
- v-sihou-msft
Microsoft Employee
I reproduced this issue. When you click the a data field directly, it may generate a chart visual automatically. In this "generated" chart, the Concatenate Label feature will not work.
However, if you click the chart icon, then populate the data field into the chart, this feature will work properly.
We have reported this issue internally.
Regards,
- v-haibl-msft
Microsoft Employee
I’ve got response from the Product Team.
This is due to a default sort that gets applied in one of the creation paths. You must have no sort (which causes an implicit sort correctly), or sort by the x-axis ascending. We are working on adding a warning for this. Please click the "..." on the visual container, and click the bold column name to remove the sort.
Best Regards,
Herbert - Tejaswini_Dahat
Helper I
Hi there,
pls refer to this article:
https://addendanalytics.blogspot.com/2019/09/x-axis-concatenation-in-power-bi.html