Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom Axis Labeling

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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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/EekgGirZ6jhGqMosPav6ASgB12z-oHvAaMLHVE2fx2ZGFg?e=4X8EX6

 

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's avatar
    sherifff
    Icon for Helper III rankHelper III
    4 years ago

    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