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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello!
The forecast tab is not working with the date table. I believe it has to do with the time intelligence functions, but I wanted to create a bar chart by month and when selecting the Year-Month in the date table, the analytics tab is not available. If I use the date on the table it shows the forecast tab, but it does not work for me because I would like to group it by month and I use the time intellingence of my date table.
Any tips or ways to solve this?
Thanks!
Is it showing a date hierarchy? In that case, you can drill till month level, while date is base. If not add a new date column
date1 = date[date]
and see you get the hierarchy for this column.
User | Count |
---|---|
98 | |
76 | |
76 | |
48 | |
26 |