Slicer Multiple Selection Displays Values Associated With Greatest Selection

[goss]

Hi all,

Using Excel 2013.

When I click on a hear slicer, I get the months associated with that slicer button
If I multi-select 2012 and 2013, I only get values for 2013

How can I get a 24 month view if I select 2012 and 2013?

My dimYear table is disconnected
I capture the slicer as a measure and use it to filter a calendar table that is connected

Year Measure: UserYear:=MAX([ReportYear])

Same for "Expense Type" in this formula, Slicer is only returning 1 item or BLANK()
UserType:=IF(COUNTROWS(VALUES(dictType[Type]))=1, VALUES(dictType[Type]), BLANK())


How do I rewrite that if I want to show 2 or more types?

thx
w

 

[theBardd]

If you are getting MAX year, even when you select two months, that measure will only return one year, the larger.

Why is your year table disconnected?