cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
moulshree172
Frequent Visitor

Date not being converted to Date hierarchy

I have a .pbix file and I have a date table which is marked as Date table but I don't have a date hierarchy. Any Idea if I can make one? Moreover, I have a Fact table named TransactionReport and I have a Date column there too, but I am unable to create a date hierarchy on it. I do not get any YEAR, MONTH, DAY, QUARTER drilldown. Any Idea how I can implement it ?

 

 

 

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@moulshree172 you can create your own hierarchy by dropping columns on each other and add multiple columns in the hierarchy.

 

Would appreciate Kudos 🙂 if my solution helped.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

1 REPLY 1
parry2k
Super User
Super User

@moulshree172 you can create your own hierarchy by dropping columns on each other and add multiple columns in the hierarchy.

 

Would appreciate Kudos 🙂 if my solution helped.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!