Forum Discussion

MLUM's avatar
MLUM
Helper I
1 year ago
Solved

Need Help Making a Date Slicer Ignore Flagged Rows

Hi!   In Power BI, i have a table with two types of records, temporary records that vary by day, and permanent records that stay the same no matter the date. I need to be able to put a table and a ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi MLUM 

     

    Please try this:
    For better testing, I did some change to the data which you provided, here's the sample data:
    Table:

     

    Then add a calculated table:

     

    Table 2 = FILTER(
    		VALUES('Table'[Date]),
    		'Table'[Date] <> BLANK()
    	)

     

     

    Next, create a measure:

     

    _Flag =
    VAR _Slicer =
        VALUES ( 'Table 2'[Date] )
    RETURN
        IF (
            ISBLANK ( SELECTEDVALUE ( 'Table'[Date] ) ),
            1,
            IF ( SELECTEDVALUE ( 'Table'[Date] ) IN _Slicer, 0 )
        )
    

     

    Finally, create a slicer with the field Table 2[Date] and replace the Table[Flag] with the measure[_Flag] in the table visual, the result is as follow:

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.