Forum Discussion
Card Filter to Current Date
Hi and good day,
Please can anyone help me on how can i filter my card base from the current date. I have calculated column, can help to convert into measure, or any other way to filter my card from the current date.
Thank you
You can add date filter only to that card visual and then select relative date option to show last 1 day including today.
Let me know if it works
Hi AllanBerces ,
You can create a calculated column in the table as
Today = IF(Table1[Date]=TODAY(),1,0)
then use this field on visual filter --> go to advance filtering --> click 1.
You can refer to a similar solution here-
Solved: Filter by today's date - Microsoft Fabric Community
Thanks.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly 🙂You can create a measure that checks if the PlanDate is today and then use this measure to filter your card.
IsToday = IF(MAX('Table'[PlanDate]) = TODAY(), 1, 0)
Assuming you want to display Percent_Daily for today, you can create a measure that filters the table for today's date and then calculates the desired value.
DAX
Percent_Daily_Today =
CALCULATE(
MAX('Table'[Percent_Daily]),
FILTER('Table', 'Table'[PlanDate] = TODAY())
)Now, you can use the Percent_Daily_Today measure in your card visualization to display the percentage for the current date.
4 Replies
You can add date filter only to that card visual and then select relative date option to show last 1 day including today.
Let me know if it works
Hi hbgv123 bhanu_gautam Anonymous thank you very much for the reply. work as i need.
Hi AllanBerces ,
You can create a calculated column in the table as
Today = IF(Table1[Date]=TODAY(),1,0)
then use this field on visual filter --> go to advance filtering --> click 1.
You can refer to a similar solution here-
Solved: Filter by today's date - Microsoft Fabric Community
Thanks.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly 🙂You can create a measure that checks if the PlanDate is today and then use this measure to filter your card.
IsToday = IF(MAX('Table'[PlanDate]) = TODAY(), 1, 0)
Assuming you want to display Percent_Daily for today, you can create a measure that filters the table for today's date and then calculates the desired value.
DAX
Percent_Daily_Today =
CALCULATE(
MAX('Table'[Percent_Daily]),
FILTER('Table', 'Table'[PlanDate] = TODAY())
)Now, you can use the Percent_Daily_Today measure in your card visualization to display the percentage for the current date.
