Year and Month Current Selections

Question

ShowSlicerContents =

IF (

ISFILTERED ( AXA_Date[Date].[Year]) &amp; ISFILTERED(AXA_Date[Month] ),

"Year:" &amp; UNICHAR ( 10 )

&amp; CONCATENATEX ( DISTINCT (  AXA_Date[Date].[Year]),  AXA_Date[Date].[Year], ", " )

"Month:" &amp; UNICHAR ( 10 )                                                                                         &amp; CONCATENATEX ( DISTINCT (  AXA_Date[Date].[Month]),  AXA_Date[Date].[Month], ", " ),

"No filter applied"

)

I am trying to create a current selections box.I can bring Year on its own and Month on its own but trying to bring them out together in a Card.Anyone see my measure &nbsp;issue above?

mariusz · Answer

Hi&nbsp;Anonymous,Please see the below and do let me know if its what you need.Year Month Selected Slicer Values = 
VAR y = ISFILTERED('Calendar'[Year])
VAR m = ISFILTERED('Calendar'[Month])
RETURN 
SWITCH(
    TRUE(),
    y &amp;&amp; m, CONCATENATEX(
        SELECTCOLUMNS(
            SUMMARIZE(
                'Calendar',
                'Calendar'[Year],
                'Calendar'[Month]
            ),
            "str", 'Calendar'[Year] &amp; "-" &amp; 'Calendar'[Month]
        ),
        [str], "; "
    ),
    y, CONCATENATEX(
        VALUES('Calendar'[Year]),
        'Calendar'[Year], "; "
    ),
    m, CONCATENATEX(
        VALUES('Calendar'[Month]),
        'Calendar'[Month], "; "
    ),
    "All Selected"
)If you have concatinated Year month field please replace the Concat in the code.Hope this helpsMariusz

anonymous · Answer

Thank you. It now works but the only thing is when nothing is selected, i get all years back&nbsp;2017 2018 2019&nbsp;when it should be blank

mariusz · Answer

Hi&nbsp;Anonymous&nbsp;Can you send your code?&nbsp;ThanksMariusz

anonymous · Answer

I am having the same issue with a Service, Owner and Assignment group alsoCode Below:It doesnt do the same for Owner or assignment group. It seems to only throw back all the results of Service.Year is doing the same thing.&nbsp;I assume it should be blank like Owner and Service are.The same applies to Year &amp; Month. Year returns everything when nothing is selected but they do work however as they should do when i do, select something,&nbsp;MappingFilter = 
VAR S = ISFILTERED('Mapping'[Service])
VAR O = ISFILTERED('Mapping'[Owner])
VAR G = ISFILTERED('Mapping'[Assignment group])

RETURN 
SWITCH(
    TRUE(),
    S &amp;&amp; O &amp;&amp; G, CONCATENATEX ( 
        SELECTCOLUMNS(
            SUMMARIZE(               
                 'Mapping',
                'Mapping'[Service],
                'Mapping'[Owner],
		        'Mapping'[Assignment group]
            ),
            "str", 'Mapping'[Service] &amp; "-" &amp; 'Mapping'[Owner] &amp; "-" &amp; 'Mapping'[Assignment group]
        ),
       "Filter: " &amp; [str], "; "
    ),
    S, CONCATENATEX( 
        VALUES('Mapping'[Service]),
        'Mapping'[Service], "; "
    ),
    O, CONCATENATEX(
        VALUES('Mapping'[Owner]),
        'Mapping'[Owner], "; "
    ),  
    G, CONCATENATEX(
        VALUES('Mapping'[Assignment group]),
        'Mapping'[Assignment group], "; "
    ),
    "All Selected"
)

mariusz · Answer

Hi&nbsp;Anonymous&nbsp;The measure should return "All Selected" when there is no filters applied, the only way it will return Year value is if the Year column is filtered.&nbsp;Are you sure you have no filters applied on the report Page?&nbsp;ThanksMariusz

Forum Discussion

Year and Month Current Selections

7 Replies

Related content

Quarter calculation upto selected month

Sorting X- axis based on Month-Year slicer selection

Dynamic Rolling 12 Months Sales Based on Selected Month

Performance by Month (Selected Month in Red)

Last 12 months from selected month