Forum Discussion

powerboss's avatar
powerboss
Frequent Visitor
6 years ago
Solved

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 m...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

Hello powerboss,

 

Can you please provide the image so that I can understand the issue clearly?

powerboss's avatar
powerboss
Frequent Visitor
6 years ago

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? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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