Forum Discussion

dharish20240911's avatar
dharish20240911
New Member
1 year ago
Solved

How to Highlight Past months

Highlight the past months in Line and stacked column chart using DAX.
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi dharish20240911,
    Thanks for Kaviraj11 reply.
    You can try the following steps
    Sample data

    Date Value1 Value2
    5//1/2024 5 7
    6/1/2024 4 8
    7/1/2024 7 4
    8/1/2024 3 9
    9/1/2024 9 5

    Create a mesasure

     

    IsCurrentMonth = 
IF(
    MONTH(SELECTEDVALUE('Table'[Date])) < MONTH(TODAY()),
    "Red",
    "Black"
)

     

    Apply the measure to the format


    Final output

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

     

dharish20240911's avatar
dharish20240911
New Member
1 year ago

This above solution is also highting the months for Oct , Nov and December if the current month is Sep

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi dharish20240911 ,
I've added a couple of later dates to the original data and still only highlight the first few months, so you can check that all your steps are working.

Best regards,
Albert He