Getting the values in Table visual comparing with multiple date column as per selected slicer value

Hi ak2812 ,

Thanks for reaching out to the Microsoft fabric community forum.

DataNinja777 , 

Thanks for your prompt response

ak2812  Based on the screenshot you have shared, below are a few suggested workarounds. I have also added the learning documents along with previously resolved cases, which may help you understand the issue better and assist in resolving it.

Workaround Options:

1. Pre-filter the data using slicers or page-level filters to reduce the row count before the visual runs.
2. Convert the measure logic into a calculated column if possible and filter on that instead. Calculated columns are evaluated during model load, not at query time.
3. Use an aggregated table that summarizes the data at a higher grain (e.g., monthly totals, category-level summaries) and point your visual to that.
4. Optimize the measure to avoid full table scans consider using variables or limiting the context with FILTER () more selectively.

DirectQuery in Power BI - Power BI | Microsoft Learn

Troubleshoot DirectQuery models in Power BI Desktop - Power BI | Microsoft Learn

Optimization guide for Power BI - Power BI | Microsoft Learn

DirectQuery optimization scenarios with the Optimize ribbon in Power BI Desktop - Power BI | Microsoft Learn

Solved: Direct Query 1 million row limitation in Power BI ... - Microsoft Fabric Community

Thanks for being an active member of the community.

Best Regards,

Lakshmi.