Allow Cross filter for charts
Allow Cross filtering for charts in Excel like in Power BI Desktop
[Deleted User] commented
I would also really like this.
Cross filtering all tables gives me a nice flat table where I can filter any level and see the result. Currently, it says I'm lacking a relationship.
I get around it by using a massive flat table in a worksheet and using auto filters, but then the charts don't refresh correctly because of the large(ish) data set.
The other problem is not being able to create Scatter plots from power-pivot results. A basic need for data analysis.
I can (and do) these things in PowerBI which is great to look at and interface with, but then I can't get the data back out to excel to analyse further (or print!!), and in PowerBI you can only have a single data series in a scatter plot which is only a little bit useful.
Currently, neither really works for me, which is disappointing as both are so close...