Forum Discussion
Helper IUnable to Create Date Hierarchy After Splitting and Recombining Date Components in Power BI
What are you planning to use the heirarchy for? It is not generally required in any of the visuals. Adding the individual columns in the right order is faster.
once the data is loaded into the Power BI report side, the same column displays the time part as well (e.g., 12/17/2010 12:00:00 AM), even though the datatype was set to date.A semantic model only has datetime column type. "Date" is only a formatting choice.
Super UserWhat are you planning to use the heirarchy for? It is not generally required in any of the visuals. Adding the individual columns in the right order is faster.
once the data is loaded into the Power BI report side, the same column displays the time part as well (e.g., 12/17/2010 12:00:00 AM), even though the datatype was set to date.A semantic model only has datetime column type. "Date" is only a formatting choice.
v-aatheequeCommunity Support
Hi Parth_1 ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!
- v-aatheeque
Hi Parth_1 ,
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!- v-aatheeque
Hi Parth_1 ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!