I am using two custom visuals - drill down donut and column chart, both zoomcharts. Filtering one of the visuals is also applying the filter to the second one, but if I want to further limit the data by applying filter in addition to the second visual, then the filter on the first one is reset. Am I missing something? Drilling filter other visuals is activated as well, but no luck there. Are they some limitation to the visuals and their filtering, which are unknown to me?
Thanks for your reply mate. I was expecting that feedback as this was my first assumption. But actually after some experimentation I was able to reproduce the issue with the standard visuals - donut and line chart. At this point it is important to mention that I am fetching the data from a database view, which should not make any difference, but still one cannot never know.
If you have validated your email address, you should see an "Attachments" below the Body of a post. If not, most folks share via One Drive, Box, Google Docs, etc.
Proud to be a Datanaut!
Let's try it like this then:
It is rather simple report with a very common use case. So I like to believe that Power BI can handle it correctly and I am actually missing something. Otherwise I will need to question the capabilities of this tool and especially the BI part of it.
I hope that I can gain some insides here, because I really like Power BI, but not having this functionality in place makes it unsuitable for me.
After my research, I'm afraid it couldn't achieve that use multiple visuals (In addition to slicer ) for cross filtering in Power BI for now.
So when you apply filter in addition to the second visual, then the filter on the first one is reset.
For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .
thank you for your feedback, I will certainly commit the idea to the Power BI ideas section. However, I am somehow disappointed, because for me this is a basic requirement to any reporting tool and I would expect that a BI tool should be able to handle that out of the box, but maybe this is my naivety speaking.