Forum Discussion
Grouping label on x-axis not working
Hi everyone,
Unfortunately the grouping of labels seems to be a bit buggy. Consider the next two graphs that are identical in terms of settings (e.g. concatenate turned off, etc.). The upper one works fine, but the lower one does not group labels. I am showing months for each year:
The formatting of fields is identical, as is the code in the Query Editor.
Right now, I am looking for a way to group the labels like the upper graph. Any help is appreciated. Thanks in advance.
I am not able to share the pbix file, since it is quite big and quite complex to replicate.
Hi BIfanatic,
Believe that the issue is regarding the Concatenation and the Continous or Categorical Type on the Axis.
Are this fields you use whole numbers or dates?
I have made the text with numbers and Dates and having the concatenation off however one thing that I notice was that the concatenation on was of when I went to the sort order (...) and choose one of the options.
Believe this is an issue with the visual. Will post a post on the issues to check if the developer team says anything.
Regards,
MFelix
4 Replies
- MFelix
Super User
Hi BIfanatic,
Believe that the issue is regarding the Concatenation and the Continous or Categorical Type on the Axis.
Are this fields you use whole numbers or dates?
I have made the text with numbers and Dates and having the concatenation off however one thing that I notice was that the concatenation on was of when I went to the sort order (...) and choose one of the options.
Believe this is an issue with the visual. Will post a post on the issues to check if the developer team says anything.
Regards,
MFelix
- MFelix
Super User
Hi BIfanatic,
Believe that the issue is regarding the Concatenation and the Continous or Categorical Type on the Axis.
Are this fields you use whole numbers or dates?
I have made the text with numbers and Dates and having the concatenation off however one thing that I notice was that the concatenation on was of when I went to the sort order (...) and choose one of the options.
Believe this is an issue with the visual. Will post a post on the issues to check if the developer team says anything.
Regards,
MFelix
- BIfanatic
Resolver I
Although the visuals were already sorted, I fixed it by sorting again and again. I don't know why it works now, but it does. It is not user-friendly though.
Thanks for your help!
- MFelix
Super User
Hi BIfanatic,
Believe this is an error since in previous version of PBI this was not working like this.
I have placed an issue in the forum:
https://community.powerbi.com/t5/Issues/Continuous-x-axis-issue/idi-p/472104
Go there and refer that you are having this issue please do.
Regards,
MFelix