Forum Discussion

Madhavi_Chilla's avatar
Madhavi_Chilla
Regular Visitor
4 months ago
Solved

Date Table relationship reducing row count in Power BI

Hi, I have a Query1 table with Invoice_Date column. I created Date_Table using CALENDAR(DATE(2017,4,1), TODAY()) Problem: - Without Date_Table relationship → 4139 rows showing ✅ - After creating...
  • rajendraongole1's avatar
    4 months ago

    Hi Madhavi_Chilla  - If you want a slicer but NOT to filter the table:

    Use:

    Visual-level filter control is not enough

    You must use a measure-based approach:

    eg., ShowFlag = 1 use this in visual filter.

     

    Or other workarounds are also there too; check this and let us know.