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.
Hi folks,
I would like to have week number and month show together in x axis. But I didnt find the off toggle of Concatenate labels in the formatting. No idea is I miss out something in the line graph. Kindly advice.
Expected outcome:
Please have a look on my pbix: https://ufile.io/66mkuot2
Appreciate any help you can provide to me.
Solved! Go to Solution.
Hi @NickProp28,
After switching off concatenate labels as:
Drill down:
Here is the output:
If you want to learn more, please refer: https://community.powerbi.com/t5/Community-Blog/How-to-change-the-granularity-of-date-in-X-axis-of-l...
Best Regards
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @NickProp28,
After switching off concatenate labels as:
Drill down:
Here is the output:
If you want to learn more, please refer: https://community.powerbi.com/t5/Community-Blog/How-to-change-the-granularity-of-date-in-X-axis-of-l...
Best Regards
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@NickProp28 , You need to week and Month(Month should have sort order) , Put both on them on the X-axis and sort on them (using three dots), Switch off concatenate labels
Dear @amitchandak ,
Thanks for the response.
I have put month and week on the axis, but the (three dot) doesnt have the sort.
Please have a look on my pbix: https://ufile.io/66mkuot2
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 |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |