Slicer Help

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.

Hi,

I am not sure how your semantic model looks like, but I treid to create a sample pbix file like below.

Please check the below picture and the attached pbix file. 

What I tried is to have disconnected slicer table.

Sales total: = 
VAR _slicerlist =
    VALUES ( 'Slicer-Calendar'[Year-Month sort] )
VAR _descriptionlist =
    SUMMARIZE (
        ADDCOLUMNS (
            _slicerlist,
            "@description", EOMONTH ( 'Slicer-Calendar'[Year-Month sort], -1 )
        ),
        [@description]
    )
RETURN
    CALCULATE (
        SUM ( sales[sales] ),
        TREATAS ( _descriptionlist, 'Calendar'[Year-Month sort] )
    )

Sales total color condition: = 
VAR _currentmonth =
    EOMONTH ( TODAY (), 0 )
VAR _priormonth =
    EOMONTH ( _currentmonth, -1 )
VAR _slicerlist =
    VALUES ( 'Slicer-Calendar'[Year-Month sort] )
VAR _condition =
    NOT (
        COUNTROWS ( _slicerlist ) = 1
            && MAXX ( _slicerlist, 'Slicer-Calendar'[Year-Month sort] ) = _currentmonth
    )
RETURN
    IF ( _condition && MAX ( 'Calendar'[Year-Month sort] ) = _priormonth, "Green" )

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

)

 

Hi RJC87,

Have you had a chance to review the solution we shared by cengizhanarslan Jihwan_Kim Murtaza_Ghafoor? If the issue persists, feel free to reply so we can help further.

Thank you.