I have googled this topic and searched the forums but I did not find anything...
The Data: I have two data models that have a relationship via the field "date". "Model A" shows the target production per day per asset (static excel sheet upload) "Model B" shows the actual production per day per asset, it is updated once per day and has hundreds of line items, for each item that was run across the asset (data flow) What I want to show is the Production vs Actual for each asset per day, month etc. in a report
The situation: On some days, assets have planned or unplanned downtimes during which they produce nothing, sometimes for one or more days in a row. When this happens, there are no rows for the corresponding dates for that asset in "Model B"
The issue: I make a table with the following layout of columns:
Date - Source: Model A: Targets Target - Source: Model A: Targets Actual Production: Model B: Actuals Difference: Calculated Measure
The issue occurs when I filter the table on a specific asset. If that asset had a downtime say on December 1, so no production data, the table automatically removes the December 1 day from the table, even though the date column has the source "Model A" which has a Target Value for December 1.
Any idea how to get Power BI not to remove the date from the table?