numeric slicer for aggregated Y axis

Hi utkarshshastri ,

Thank you for the update.

The “Resources Exceeded” message means Power BI is processing too much data at once, likely because SUMMARIZE with RELATEDTABLE is being used on the large Marketo_Leads and Marketo_Campaign_Activity tables.

To fix this:

Use Power Query’s “Group By” to pre-aggregate data by LEAD_MAIL_DMN_NME and create a summarized table (Lead_Count_Summary_PQ), which helps avoid heavy calculations at runtime.

Alternatively, in DAX, limit summarization to more recent data, for example:

Lead_Count_Summary =
VAR RecentLeads =
    FILTER (
        'Marketo_Leads',
        'Marketo_Leads'[MONTH_START] >= DATE(2024,1,1)
    )
RETURN
SUMMARIZE (
    RecentLeads,
    'Marketo_Leads'[LEAD_MAIL_DMN_NME],
    "LeadCount", COUNTROWS (RELATEDTABLE('Marketo_Campaign_Activity'))
)
​

If your dataset is currently set to DirectQuery mode, consider changing it to Import mode to help lower the query load.

Let us know if these changes resolve the issue, or if you continue to experience resource limitations. Hope this help you .

Thank you.