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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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:

Custom Sorting in Power BI 

Regards,

Xiaoxin Sheng