Forum Discussion
Does someone know if bi-directional cross-filtering will appear in Power Pivot?
MicrosoftAshvini Sharma, Olaf Hubel - any news here? And more general question - why DAX for Excel is far behind Power BI Desktop and even SSAS? My guess they use the same engine.
For example, recently introduced TREATAS() for Power BI desktop looks like on hold for Power Pivot.
My question is practical - for more or less complex models i prefer to build them in Excel and only on final stage to shift on Power BI Desktop (or directly publish to Power BI services). Above incompatibilities push me to switch directly on Power BI Desktop, but that's not what i'd like to do.
Thank you
I would think that the fast update path is Excel 2016 on Office 365, but I haven't seen the roadmap. There are FILTER and INTERSECT alternatives for TREATAS() as mentioned here ... https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
Mark, i checked the roadmap few days ago (new one) and found nothing. But that doesn't matter. My question is more general - if Power Pivot is considered as legacy tool by Microsfot perhaps i'll shift one day on Power BI Desktop. Even if i don't like this and Excel is much more comfortable for me.
Yes, why i re-initiated this post since i read mentioned article.
Just wanted to also say thank you for this feedback on such an important feature.
I totally understand if there will be differences between PBIX and XLSX, particularly on the visualization layer, but I'd hope that the data retrieval, shaping/transforms, and modeling features stay closely aligned such that it's easier to move between the tools and choose the right one for the given scenario.
-Brett
- Ashvini, thank you for good news. CROSSFILTER() helps, but with built-in interface for bi-directional cross-filtering life will be bit more easier.
