Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

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...
  • hbgv123's avatar
    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

     

  • Anonymous's avatar
    Anonymous
    1 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 ðŸ™‚

  • bhanu_gautam's avatar
    1 year ago

    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.