Forum Discussion

RJC87's avatar
RJC87
New Member
7 months ago
Solved

Slicer Help

Hi,   New to the forums so hope this is the right place for this but wanted some advice to see if this is do able or if Im just chasing ghosts. I have a report that is based on monthly data, I have...
  • AWD's avatar
    AWD
    7 months ago

    Hi RJC87 ,

    Please see the below screenshot, if I understand correctly, you just need the current month to highlighted irrispective of what month the user selects, in the below, the user has selected Mar-26 but the current month is Jan-26.

    To achieve this I have used the folllowing DAX:
    _Current Month Highlight =
    VAR CurrentMonth =
    FORMAT ( TODAY (), "MMM-YY" )
    VAR SelectedMonth =
    SELECTEDVALUE ( _Date[Month Year] )
    RETURN
    IF ( SelectedMonth = CurrentMonth, 1, 0 )

    Using the Button Slicer visual, I have changed the Callout>Background conditional format to use this DAX where the value = 1. You will need to amend the table and column names to look at the apropriate table, you will also need to change the formatting to "MMM YYYY" (based on your snippet).

    If your definition of "current month" is not 'today' then you can also use EOMONTH() to adjust it +/- X number of months appropriate to your definition.

    Hope this helps, please consider marking it as a sollution and providing a thumbs up as it helps others find this solution. Thanks 🙂

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
7 months ago

Create a measure:

Current Month Label =
"Current report month: " &
FORMAT ( EOMONTH ( TODAY(), -1 ), "MMM yyyy" )

 

Then:

  • Show it in a Card or Text box

  • Use conditional formatting (green background / icon)

This gives users an immediate visual cue, even if they deselect it in the slicer.