Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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:
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.
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:
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.
Thank you for your help, @v-rzhou-msft! 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?
Hi @Anonymous
You may build a calendar.
Here I have a test. Firstly I build a calendar table(date) as below:
You can download the pbix file form this link:
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.
Hi @v-rzhou-msft ,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |