Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |