Custom Axis Labeling

[Anonymous]

Is it possible to modify the labeling on an axis?

For example, I have a line chart with quantities on the y-axis and iso week numbers on the x-axis. Instead of displaying the week number (1, 2, 3, etc.), I want to display months (January, February, March, etc.). Here's the rub: I still want to analyze by week.

If you can help me figure this out, I'll be grateful!

[Anonymous · Accepted solution]

Hi @Anonymous 

You can add a Month Column and use Dirll up and Drill down operation.

Table:

Drag Month Column into Axis:

Result:

Then we need to turn off Concatenate labels in X axis.

Trun on the Drill Mode and Click the Month we want to search:

Or Click here to see all data in this visual:

You can download the pbix file form this link:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/tongzhou_qiuyunus_onmicrosoft_com/EZRqvPHvrOhFpF51...

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

Thank you for your help, @Anonymous! Your solution worked for the issue I had, but now I have a new problem: my graph breaks apart. Do you (or anyone else) have any thoughts on how to fix it?

[Anonymous]

Hi @Anonymous 

You may build a calendar.

Here I have a test. Firstly I build a calendar table(date) as below:

date = CALENDAR("2020/1/1","2020/2/1")

Result:

Then build a table with Non-consecutive dates:

Build relationship between two tables and build a line chart.

X Axis use Date column in Date Table, value use Column1 in Table.

Result:

The line chart has been fixed.

You can download the pbix file form this link:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/tongzhou_qiuyunus_onmicrosoft_com/EekgGirZ6jhGqMos...

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[sherifff]

Hi @Anonymous ,

I am having similar issue. I was trying to access the pbix files which you posted both of them are not working. 

could you plz share the pbix file .

thanks