Forum Discussion
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
Resident 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
- AnonymousNot 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
Resident 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
- AnonymousNot applicable
Sorry, I didn't notice your response as the replies got caught up in one of my Outlook Rules.