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, 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!

Need Help
Tips and Tricks

4 Replies

  • 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.