Forum Discussion

E_Rye's avatar
E_Rye
Frequent Visitor
7 months ago
Solved

Can rows be hidden from a Table visual without removing the rows from a measure shown in the Table?

Hello, Is there a way to filter/hide rows in a Power BI table visual and keep the associated measure counts for those rows? My table below summarizes a 36 month lookback for IDs which have a li...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • E_Rye's avatar
    E_Rye
    7 months ago

    I have found the solution is to create a visibility flag measure to identify the rows that are within 24 months of the current date, as below, and then use that measure as a filter on the visual.  For some reason the visibility flag measure does not working for 'Filters on this page' but does work for 'Filters on this visual'.

     

    Within24Months (measure) =
    VAR CurrentDate = TODAY()
    VAR RowDate = MAX('Date'[Date])
    VAR MonthDifference = DATEDIFF(RowDate, CurrentDate, MONTH)
    RETURN
        IF(MonthDifference >= 0 && MonthDifference <= 24, 1, 0)

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 months ago

You are welcome.  I am still confused.  I do not know the result that you are expecting.

E_Rye's avatar
E_Rye
Frequent Visitor
7 months ago

Final result is to display 'Reporting Month' range = 1/1/26 - 2/1/24 and filter/hide 'Reporting Month' more than 24 months from current month (2/1/23-1/1/24) while keeping the corresponding 'Active IDs During Reporting Month' shown in my table visual.

I have tried filtering several different ways (see original post) but not getting the needed result.

 

Thanks again!