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 

 

You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

 

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