Change list of values in Slicer Based on Selection in Another Slicer

[untruthtotruth]

I have two Slicers

1 Firm

2 Month End

I have multiple Firms and each Firm has data for Month ends. I have a requirement where if more than one Firms are selected then 

MonthEnd Slicer should show only Quarter End Months else Show MonthEnd.

Please let me know if anybody has solution to this

Thanks

[Anonymous]

Hi @untruthtotruth ,

I create a table as you mentioned.

Then I create two calculated columns.

Column = 
IF ( MONTH ( 'Table'[Date] ) IN { 3, 6, 9, 12 }, "Quarter End", "Month End" )

Column 2 = COUNTROWS(VALUES('Table'[FirmName]))

Fianlly I create a calculated column and get what you want.

Column 3 = 
IF (
    'Table'[Column 2] > 1,
    IF (
        'Table'[Column] = "Quarter End",
        FORMAT ( 'Table'[Date], "MMM YYYY" ),
        "Month End"
    ),
    FORMAT ( 'Table'[Date], "MMM YYYY" )
)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[untruthtotruth]

Hi @Anonymous ,

 Thanks for replying. I looked at the solution that you have provided. In my secenario Each FirmName has Multiple Monthends and I have 2 slicers, FirmName slicer & Slicer2 Monthend.

  IF in ColumnA(Firm Name) Slicer, Single Firm is selected then Slicer2 should show Monthends related to that firm But IF multiple Firms are selected in Slicer1 then Slicer2 "Report Date" should Only show QuarterEnd Values. I looked at the PBIX file if you select Multiple Firm, Date filter if not showing only Quarterend Values