Filtered Date

[jgamenara]

Good afternoon

I need help. I want the records greater than the selected date to be returned to a table chart by selecting a date up to (e.g. until 01/10/2020).

This date is related to the card

This chart has a different date field than the one you mentioned earlier.

I need you to show the records greater than the date selected above

What do you advise me to do? I hope I've been clear.

Thanks for the help.

Best regards

Juan

[Anonymous]

Hi @jgamenara,

You can consider switching your slicer to 'after' mode then it will filter all the records that large than or equal to the selections.

If you did not want to change the default slicer mode, you can also break the relationship from the source fields that the slicer used to the fact table.

Then you can write a measure formula to check the selected value, compare with table records, and turn tag. You can use it on the visual level filter of your table to filter records.

Applying a measure filter in Power BI 

Regards,

Xiaoxin Sheng

[AllisonKennedy]

@jgamenara It sounds like your date slicer is not connected to the table you want to filter? You should be able to use the DAX in this blog to help. https://blog.enterprisedna.co/show-days-before-or-after-a-selected-date-using-power-bi/