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 relationship between dates table and data table exists based on date. For all rows data exists for each month. Tried filtering in query editor but that does not work (or I'm doing the wrong thing).

Anyone any ideas how to accomplish this?

 

Regards,
Sander

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)

4 Replies

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