Forum Discussion
Card Filter to Current Date
- 1 year ago
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
- Anonymous1 year ago
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 🙂 - 1 year ago
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.
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 🙂