Card Filter to Current Date

[AllanBerces]

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. 

Today_Column = if('Table'[PlanDate]=TODAY(),"Today",""& 'Table'[PlanDate])

My Table are all Measure, the Card should reflect Percent_Daily = 28.36

Thank you

[hbgv123 · Accepted solution]

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

[Moana · Accepted solution]

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 🙂

[bhanu_gautam · Accepted solution]

@AllanBerces 

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.

[Moana · Accepted solution]

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 🙂

[hbgv123 · Accepted solution]

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

[AllanBerces]

Hi @hbgv123 @bhanu_gautam @Moana thank you very much for the reply. work as i need.