Automatically show data set for todays date

[Jacks060650]

Hello Powerbi people,

Hope your all well? 🙂

Would someone be able to kindly help me, I have made a dashboard please see image attached.  "Budget" will automatcily feed from a table and so will the prebook and daycode. I have attached a image of the setup of the excel table which is in powerbi. How would you automaticly show each data set for "todays current date" if that is possible?

Many thanks,

[khaledHabib90 · Accepted solution]

There are a few ways to tackle this, one suggestion would be to create a calculated column in power bi, or in power query a custom column. Which compares the date column with today's date. For example the dax calculated column would have the below formula

ColumnName = date = today()

This will return True for todays date, and False for any other date

You can now use this column as a filter on your page, and filter the true value only 

If my reply helped you solve the issue, please accept it as the solution 🙂