> Thanks for this, i am aware of this picture method but it cant be translated into card format, i believe power bi as not provided a method of changing that into tables.
Yes and no. I don’t believe that there’s a way to access the forecasted data completely dynamically, but you can access it in the following way and use it in cards, visuals, etc.
When you run the forecast analytics, it gives you the option to “show as table”. If you do so, you will see three new created columns at the bottom of the table - one with the forecast values, and the others with the upper and lower confidence band limits. You can now export that info to CSV and then re-pull it into your Power BI report via Power Query. Once you do that, the forecast data just becomes regular columnar data that you can use in other analyses, visuals, etc. It would be ideal if you could call this forecast data dynamically (say, in a virtual table), but I don’t believe that’s currently possible. Regardless, the technique described above and pictured below may make the analytics pane approach usable for your requirement.