Applying a filter to a table, without applying to a common date.

[Anonymous]

I have several visualizations and a table on my page.
Can I somehow show in the table only rows where the column "end date" is empty, while not affecting other visualizations?

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.

Not if date is joined with the start date you can have visual level filter to get end date is blank

if is joined with end date , have the measure with +0 and show 0 rows

Measure = countrows(Table) +0
Appreciate your Kudos.

[Anonymous]

Perhaps with a picture it will be clearer.
Here is my page; there are some visualizations on it that are related to general information.
I need the bottom table to show only rows without an end date, but all the total visualizations show information about all records.
In this case, when applying filters, the table should also change.
If I select a section, then all indicators show information about the section, and the bottom table shows the lines with no dates in this section.

[amitchandak · Accepted solution]

@Anonymous , Two way, Have measure that ignore issue date , Assumes issue date is joined with Date table

Calculate([Measure],All(Date), filter(table,isblank(table[enddate])))

Or switch of interaction with date filter

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

Or refer to my blog deal with open between dates

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Anonymous]

@amitchandak Thank you very much for the link.
As a solution, I added a slicer in which I selected an empty end date and, using interaction, made it so that this slicer only affects the table.
Not the prettiest solution, but it works.

[amitchandak]

@Anonymous , Yes sometimes the solution is more important than approach. As long as it meets end-users needs. 😀