Forum Discussion

AndrewLGoldman's avatar
AndrewLGoldman
Icon for Advocate I rankAdvocate I
6 years ago
Solved

Year Filter on Filters Pane Requiring Single Selection Disables Single Selection If User Deselects

Hey Power BI Community,   Not sure if anyone else ran into this or has any ideas, but I would be so grateful if anyone had any ideas!  Right now on one of my Power BI Desktop reports I have a filte...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi AndrewLGoldman ,

     

    Are you mean you want years can't be multi-selected but months can be?

    Measure = IF(CALCULATE(DISTINCTCOUNT('Table'[yearmonth].[Year]),ALLSELECTED('Table'))>1,BLANK(),1)

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi AndrewLGoldman ,

 

Are you mean you want years can't be multi-selected but months can be?

Measure = IF(CALCULATE(DISTINCTCOUNT('Table'[yearmonth].[Year]),ALLSELECTED('Table'))>1,BLANK(),1)

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

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

AndrewLGoldman's avatar
AndrewLGoldman
Icon for Advocate I rankAdvocate I
6 years ago

Apologies for the delay in response!  I can see how that solution would definitely work, but I actually had a standard date column I set custom formatting to be in the style of "mm yyyy" and enabling 1 slicer instead of 2 without drill up/downable functionality