Color value

Hi LeaRupnik ,

Thanks for the update, and sorry to hear the issue is still ongoing.

Since the report keeps processing indefinitely and eventually fails, this suggests there may be a more serious performance bottleneck or memory-related issue during calculation.

Here are a few workarounds that can help:

1.Try breaking down the [ODM Barvanje Base] logic and testing each part in a simple visual — ideally filtered to a small date range or a single ODM Odpoklic_ID. This can help identify which part is causing delays or failure.

2.Ensure the summary table is correctly implemented to avoid complex on-the-fly calculations:

SummaryTable =
SUMMARIZE(
    'f ODM Odpoklici_MES',
    'f ODM Odpoklici_MES'[ODM Odpoklic_ID],
    'f ODM Odpoklici_MES'[ODM Datum_odpoklica],
    "Kolicina", MAX('f ODM Odpoklici_MES'[ODM Kolicina_po_odpoklicu]),
    "ZalogaKoncni", MAX('f ODM Odpoklici_MES'[ODM Zaloga_koncnih_kosov]),
    "ZalogaMehanska", MAX('f ODM Odpoklici_MES'[ODM Zaloga_mehansko_obdelanih_kosov])
)

You can then use this table in your measures instead of querying the full fact table. This significantly improves performance.

3.If you’re not familiar with DAX Studio, you can use Power BI’s built-in Performance Analyzer:

• Go to View > Performance Analyzer
• Start recording, then refresh the visuals
• Identify which visuals/measures are the slowest
• You can click Copy Query and share it here if needed

As highlighted earlier by super user, the TOPN logic is the correct way to retain the last known colour state when no data is available for a specific date. Just ensure:

• Your date table is marked as a proper Date Table and contains a continuous range of dates.
• You can use [ODM Barvanje Trajno1] for conditional formatting in visuals.

Regards,

B Manikanteswara Reddy