Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Can anyone help me,
My aim to get my bar diagram in a correct order( November 2021data should be left side and the latest data in right hand side).
My created time table data format is DD/MM/YY HH:MM:SS , However i just used only year and month
This is a line and cluster coloum chart
Solved! Go to Solution.
@Aslam , You should expand in that case so that year stays with the month and it gets sorted first by year and then a month. Seem like you have to use the next level
or create a date table with month and year with the correct sort column(mark that as a sort column) and use that
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
@Aslam , You should expand in that case so that year stays with the month and it gets sorted first by year and then a month. Seem like you have to use the next level
or create a date table with month and year with the correct sort column(mark that as a sort column) and use that
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |