Dynamically filtering rows

[SandervdM]

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

[v-diye-msft · Accepted solution]

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.

[v-diye-msft]

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.

[SandervdM]

ok, thanks for the hint.

Attached a link to a PBIX file with the data

https://1drv.ms/u/s!Ai7aUwtUNnYVmB_RgO20M4wgpe8O?e=v2qZIj

Desired result as displayed in the picture below. When selecting the month of December in the slicer an additional row is displayed.

[v-diye-msft · Accepted solution]

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 · Accepted solution]

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)