Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have created a date filed to use that a master slicer, however for some reason the date field does not seem to be aligned.
Any help is really apprecited 🙂
Solved! Go to Solution.
Hello All,
I managed to get it sorted, the reason why it was not aligning was, there was a time stamp in the dates for one and the otherone was showing 00:00:00 instead of actual hh:mm:ss. I forced it to be date, instead of Date/Time and was able to do the user relations perfectly.
Thanks a lot for all your support 🙂
hi @JCK2
In the first picture, [NC Date Opened] and [Date] are two columns, how do you keep them aligning?
Regards,
Lin
Hello All,
I managed to get it sorted, the reason why it was not aligning was, there was a time stamp in the dates for one and the otherone was showing 00:00:00 instead of actual hh:mm:ss. I forced it to be date, instead of Date/Time and was able to do the user relations perfectly.
Thanks a lot for all your support 🙂
If you all dates are in DD/MM/YYYY format then use this setting
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
or you can create new column to convert it into mm/dd/yyyy format
mid(DD__MM__YY[Date],4,2) &"/"& left(DD__MM__YY[Date],2) & "/" & right(DD__MM__YY[Date],4
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |