Create a table for today

Hi, 

According to your description, I can clearly understand your requirement, I think you can simply achieve your requirement by creating a calculated table like this:

Data Today =

FILTER('Table',[Date]=TODAY())

And you can get what you want, like this:

If you don’t want to create a table that is stored in the dataset and just want to make it displayed in the dashboard, you can apply the “Relative date” filter on your visual like this:

For more info:

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range#create-the-relative-date-range-filter

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.