You can work around this with some DAX... Not ideal I realise, but take a look at my example here: https://1drv.ms/u/s!AhrHQG3fCq7Rsu0Z8MhPKuWN3nkt6A
We released a preview of a new matrix visual with today Power BI Desktop release. This new matrix can be used as a source of cross-highlighting, has a stepped layout, can be drilled in to /out of hierarchies, and has performance updates.
You can read all about it in our blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/#matrix
During the preview we will be adding even more new features, so keep watch each month for more improvements and let us know in comments what else you’d like to see.
@Dewayne, that's a great request as well - can you please create another idea so we can track it separately? It's hard to parse out all the individual requests from this one massive idea! Thanks!
@Sanjay, you can use Excel against your Power BI datasets already. https://powerbi.microsoft.com/en-us/documentation/powerbi-service-analyze-in-excel/ You can't put Excel sheets into Power BI reports, but that's a good idea - please go ahead and create another post here so we can track it. Drilling from Power BI reports to somewhere else (another report, another dashboard, another webpage etc.) is on our backlog and you can help prioritize that by voting here: https://ideas.powerbi.com/forums/265200/suggestions/13715889
@marcelo - Yes, that's it!
It's not a complete solution, but there some advanced Join options when you use the Merge function in Query Editor... You can do inner/outer, left/right/full and anti joins. We don't support multi-joins, but you can create bridging tables and use those. We don't support other operators than "=", but we don't hear many requests for it so until this gets lots of votes we probably won't be able to prioritize that work. Hope that helps!