Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Manual filter for slicer

Hey, I would like to have slicers in the following way: 

1st slicer: select company(forced single selection)

2nd slicer: select contract ids (multiple selections possible, but only 1 per year), so my question is: can I create a manual  filter for the id slicer, that if there has already been chosen 1 id for year x, then it is not possible to chose another id of year x

 

My table contains: company name, contract id, year as columns and some others

 

Thank you!

 

Need Help

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    hi, Anonymous 

    Based on my research, It is not supported to implement your demand in Power BI currently.

    As a workaround, you could create a measure that if there are more than one id is selected in one year, the result will not show.

    For example:

    This is sample data

    Then write a measure

    for filter = 
CALCULATE(DISTINCTCOUNT('Table'[contract id]),FILTER(ALLSELECTED('Table'),'Table'[year]=SELECTEDVALUE('Table'[year])))

    And drag it into visual level filter and set is 1

    Result:

    and here is sample pbix file, please try it.

     

     

    Regards,

    Lin