Forum Discussion
Being able to cross filter visualization even when value is zero
Microsoft EmployeeHi Anonymous,
I have asked the Product Group and they have replied me that it is by design now and they will allow the user to click on the category label (the text) to cross-filter other visuals in the Spring of 2019, so I am afraid you could not filter other visualizations by using zero value currently, I suggest you could create a table or matrix visual below it to filter:
Regards,
Daniel He
I made a workaround which makes me not have to create an extra visual or slicer. Basically I created an extra invisible bar which if selected filters the exact same thing as the other bar. The white bars in the image are selectable and filter my other visuals. I would like to be able to make them transparent but I do not think there is an option for that?
- v-danhe-msft
Hi Anonymous,
Based on my test, i am afraid you could not have this option to meet your requirements, you could submit an idea in ideas forum:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Daniel He