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 ...
Need Help
  • 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.

gmsamborn's avatar
gmsamborn
Super User
1 year ago

Hi MLUM 

 

You could a measure like this to filter your visual.  

 

 

Include = 
VAR _SelDt = MAX( 'Date'[Date] )
VAR _Result =
    IF(
        SELECTEDVALUE( 'Table'[Flag] ) = 1
            || (
                SELECTEDVALUE( 'Table'[Flag] ) = 0
                    && SELECTEDVALUE( 'Table'[Date] ) = _SelDt
                ),
        1,
        0
    )
RETURN
    _Result

 

 

Let me know if you have any questions.