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.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi AndrewLGoldman ,

 

A possible workaround and depeding on your visualizations is on your measures make a similar sintax to this one:

 

Measure =  IF(DISTINCTCOUNT(Table{Year]) > 1 , BLANK(); [Measure]))

 

This will blank out your data, but again depends on how you have your data setup.