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.
Hi,
With my setting to turn on "Auto date/time", as I understand this will automatically convert our date fields into having date hierarchy. Is there an option to turn off or display the original in some of the field ONLY ?
Meaning I still want to use that feature for some date field, but there are time I may not need that for some display or some other date in my other table.
Thanks
Solved! Go to Solution.
@VoltesDev , on the visual where you want to display the date only, click the drop down arrow next to the Date Hierarchy and choose the 'date' option.
However, I do recommend you create a dimdate table and use that custom hierarchy instead: https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@VoltesDev , on the visual where you want to display the date only, click the drop down arrow next to the Date Hierarchy and choose the 'date' option.
However, I do recommend you create a dimdate table and use that custom hierarchy instead: https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thanks, this is what I needed 😊
Thanks also @amitchandak , I do know however the setting, only I want it not for all. Thanks again,
@VoltesDev , setting to turn off for all. In options and setting -> options -> Data load (Global/file level) -> Auto time intelligence off
Also when join date to a date of the date table, which is marked as a date table, you will not get the date hierarchy
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |