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 ,

 

Thanks MFelix  to give the direction.

I modified the formula and used ALLSELECTED() function.

Here's the formula i used and the result as below. 

 

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

 

What we need to do is adding this measure to visual level filter.

 

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

    Thanks Anonymous  MFelix - those are great ideas for blank-ing out the data in the data tables!  Works like a charm!  Nice save for some of the data tables

     

    Would either of you maybe have any ideas for charts as well?  For example, a simple bar chart with MM-YYYY on the axis and some value as the value -- when a user deselects a year and let's say there's 5 years worth of data (e.g. 2016 - 2020), the bar chart expands horizontally exponentially with 60 columns when I rather just show 1 year's worth of months or even better no data or axis at all as opposed to every month between the first year and last year in the data set


    I guess I could show just the month name but I find it's much more visually appealing to keep it in the MM-YYYY format

     

    Any ideas?

    Thanks again for the really good idea above though, that's great!

    • 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