Forum Discussion

SandervdM's avatar
SandervdM
Frequent Visitor
6 years ago
Solved

Dynamically filtering rows

I'm having an issue in excluding rows from a table (visual). From 10 rows I want to show 2 rows only in December; all other rows are shown each month. Using a slicer the user can choose a month, so r...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi SandervdM 

     

    Add the measure:

    Measure = var a = SELECTEDVALUE(Dates[monthName])
Return 
IF(a = "December"&&"Third row" in VALUES(List1[Description]),0,1)

    Then drag it to the filter pane with the measure is not 0:

     

    Pbix attached.

  • SandervdM's avatar
    SandervdM
    6 years ago

    Almost perfect: now the line "Third Row" is NOT visible when selected December in the slicer. Updated the if statement with a not() and it worked.

     

    Thanks.

     

    Measure = var a = SELECTEDVALUE(Dates[monthName])
Return 
IF( NOT(a = "December") &&"Third row" in VALUES(List1[Description]),0,1)
v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi SandervdM 

 

Add the measure:

Measure = var a = SELECTEDVALUE(Dates[monthName])
Return 
IF(a = "December"&&"Third row" in VALUES(List1[Description]),0,1)

Then drag it to the filter pane with the measure is not 0:

 

Pbix attached.

  • SandervdM's avatar
    SandervdM
    Frequent Visitor
    6 years ago

    Almost perfect: now the line "Third Row" is NOT visible when selected December in the slicer. Updated the if statement with a not() and it worked.

     

    Thanks.

     

    Measure = var a = SELECTEDVALUE(Dates[monthName])
Return 
IF( NOT(a = "December") &&"Third row" in VALUES(List1[Description]),0,1)