Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hey Guys,
probably obvious, I have a field 'Created' of type Date in a table, and I have other table created using Dax fuction CALENDAR the field 'MyDate' type is Date as well , now when I create a relationship between 'Created' and 'MyDate' I loose date hierarchy capabilities on 'Created' field on visualization
However I still get to see date hierarchy if I use 'MyDate'.
why is it like this?
Solved! Go to Solution.
Hi @saxenaa,
It seems to be the default behavior, and I don't think there is an option to change it currently.
An alternative solution is to create a new calculated column "Created2= 'theTable'[Created]" in your table and then use Created2 column instead to get hierarchy back. ![]()
Regards
Wow this software is so limited.
hi all,
i have been using data source as cosmosDb in powerbi to create report.Yeaterday i created few reports by using date hierarchy.today i was opening the report my date hierarchy was missing and drilldowns are not working.becuse obviously there is no date hierarchy to work fro drilldown can someone please help me with this.
Hi @saxenaa,
It seems to be the default behavior, and I don't think there is an option to change it currently.
An alternative solution is to create a new calculated column "Created2= 'theTable'[Created]" in your table and then use Created2 column instead to get hierarchy back. ![]()
Regards
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 57 | |
| 44 | |
| 41 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 183 | |
| 114 | |
| 93 | |
| 61 | |
| 45 |