Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How can I prevent one filter from removing items from another filter

I have a report where I use DAX to cocatenate  filter selections. The DAX is easy using FILTERS() and CONCATENATEX(). The problem I have is when I select items from one filter, Power BI automatically removes items with no data from other filters. I need to prevent that behavior? Anyone know of a way to do it? 

  • Hi Anonymous ,

     

    You may could try the feature Interaction between visuals.

     

    If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi Anonymous ,

     

    You may could try the feature Interaction between visuals.

     

    If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable

      This is what I ended up doing. I used Slicers instead of filters and turned off the filter interaction in the slicer visuals.

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi Anonymous ,

     

    Have you solved your problem?

     

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable

      Sorry, I didn't notice your response as the replies got caught up in one of my Outlook Rules.