Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hello,
I am Looking to create a matrix that can do forecasting, anyone know if this is possible? I can create a forecast within a line graph using the analycis tab but I can not do the same on a matrix. any help would be great! Thank you
Hi @Anonymous,
Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
BTW, if you want to show forecast date ranges that not exist on your matrix, you need to use the disconnect date table as a category and write measure expressions to show the result based on current values.
Regards,
Xiaoxin Sheng
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.