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 🙂

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

I am not aware of your datasets, so i created a sample files but i am  not allowed to attached the PBIX file @Natalie_iTalent (FYI)

Please create two measures.and create month key column, based on that you apply conditional formatting, please let me know if this works for RJC87 and accept this as a solution for others to easily found that in future, thanks
 

Current Month Label =

 var current_month_key =

YEAR ( TODAY() ) * 100 + MONTH ( TODAY() )

RETURN

current_month_key
Highlight Current Month =

VAR SelectedMonth =

    SELECTEDVALUE ( 'Current Month Highlighted Data'[Month Key] )

RETURN

IF (

    SelectedMonth = [Current Month Label],

    1,

    0

)