The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I have created a relationship between two tables: Order data and forecast data (måltabell). When I create a table in the report view with actual orders (sålda) and forecast data (Mål), the forecast data is not always showing. Forecast data is only showing when there are actual orders on product level. In table below since we have no actual orders for product T1, the forecast (Mål) is not showing. However the forecast should be 625. The actual (sålda) is showing 95 since it is product T3.
How can I make sure that even when there are no actual order for a specific product I can still see the forecast?
Solved! Go to Solution.