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

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/EZRqvPHvrOhFpF51xuNC0uYBxs4gJ-ngL3u7Aw0u-e3xGQ?e=NteNYf

 

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'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