Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Nazeem81
Helper I
Helper I

Forecast value not showing

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?

 

 

Mål is missing.PNG Relation.PNG

1 ACCEPTED SOLUTION
Lind25
Resolver I
Resolver I

You could try restructuring the relationship between your order and forecast tables. Use a dimension table (i assume this would be product) that filters both your data tables rather than connecting your data tables.

View solution in original post

1 REPLY 1
Lind25
Resolver I
Resolver I

You could try restructuring the relationship between your order and forecast tables. Use a dimension table (i assume this would be product) that filters both your data tables rather than connecting your data tables.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.