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
    6 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)

     

danextian's avatar
danextian
Icon for Super User rankSuper User
6 months ago

You can conditionally forma Show row to be transparent and replace the column name with a blank space.

Use this measure as a field value in conditional formatting dialogue

Transparent = "RGBA (0, 0, 0, 0 )"
E_Rye's avatar
E_Rye
Frequent Visitor
6 months ago

Hi danextian,

Am I understanding correctly that the "Transparent" measure used in the conditional formatting dialogue disappears the 'Show Row' column values?

 

The 'Show Row' column is for context and will be removed from final dashboard but thanks for the cool trick! 

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    6 months ago

    It just makes it invisible in the visual but if the data is exported, it will be included.