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
as you can see my Report date doesn't have that calendar logo in front. But i have checked the formats are the same. Thanks!
It's chcked but seems like it's not really groupped.
Hi @GAPER ,
Please follow these steps:
If you defined a column as a date data type in the Power Query editor, but Power BI does not automatically generate a date hierarchy, check the Power BI Options. It could either be disabled Globally for all files, or for the Current File
Navigate to File > Options > Data Load for both Global and Current File, ensure that Auto Date/Time is enabled under the Time Intelligence section.
You can also manually create a date hierarchy.
You can right click on a date field and choose Create Hierarchy.
Best Regards,
Community Support Team _ Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 36 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |