Forum Discussion
Automatically show data set for todays date
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,
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 🙂
1 Reply
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 🙂