Forum Discussion
How To Change X-Axis Labeling
So I created this thread: https://community.powerbi.com/t5/Desktop/How-To-Differentiate-2-Different-Items-On-Line-Chart-With-Same/m-p/889434#M426406
My main problem now is the X-axis looks very muddy. Is there a way I can just have the years in intervals, i.e. "2015", "2016", then "2017", etc...
Thank you.
HI powerboss,
It sounds like you want to group your axis label based on category fields. If this is a case you can enable this effect by modifying the x-axis type to 'categorical' and turn off the 'concatenate label' option. (notice: don't forget to set 'sort by' current axis fields to enable axis grouping)
Regards,Xiaoxin Sheng
4 Replies
I am limited in how much I can share, however for this X-axis I drilled down to include two categories: the date and the order number.
Right now it looks like this:
I need to include the order# in the drill down category in order to separate it, however it now includes it in the x-axis labeling, making it look terrible.
Any ideas?
HI powerboss,
It sounds like you want to group your axis label based on category fields. If this is a case you can enable this effect by modifying the x-axis type to 'categorical' and turn off the 'concatenate label' option. (notice: don't forget to set 'sort by' current axis fields to enable axis grouping)
Regards,Xiaoxin Sheng
HI powerboss,
You can write a measure with some variables to stored extract current category and year, then you can use them to find out previous records.
After these, you can aggregate table records that filter by above parameters and compare/calculate between different values.
In addition, I'm not so clear for your table structure, can you please share some dummy data and expected results for test?
How to Get Your Question Answered Quickly
BTW, you can also take a look at the following blog about custom soring:
Regards,
Xiaoxin Sheng
