Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi all,
why the date hierarchy does show in the axis.
my date column is already formatted to date.
i have a calendar table & relationship is linked to it. Any advice?
Solved! Go to Solution.
@Anonymous
Make sure you create Date table using calendar command
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Is it marked as date table? Right click on table Name. There is an option
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
@amitchandak @SivaMani I got error "date column can't have gaps in dates"
any idea how to solve that?
@Anonymous
Make sure you create Date table using calendar command
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Hi @Anonymous ,
It's impossible to sue "date hierarchy" if you use "Direct Query" connection model.
And as tested, the date hierarchy cannot be displayed if this column is linked to other column.
The impact of table relationships on date hierarchies
1:1
1:*
(1: the date can use hierarchy; *: can't)
*:*
Smmarize: only one side of the date can use the date hierarchy.
So you may need to modify your table model.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous,
Please check the below cases,
Hope it will help you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |