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