topic Re: Pivot table functionality in Desktop

Pivot table functionality

ryan031581 — Thu, 25 Jul 2019 21:35:11 GMT

This is an old office xp web component. You can collapse/expand every hierarchy or attribute to analyze data using the buttons in the table. I'm looking for something similar such as Excel or Power BI, but none of them are fitting our needs. Power BI's matrix table is clunky. You have to click buttons not even in the table (top right) to expand/collapse and you can only expand/collapse the entire dimension and not just one attribute you're trying to analyze further like I can below in the office xp web component. Has anyone seen anything close to the functionality of this archaic technology?

Re: Pivot table functionality

parry2k — Thu, 25 Jul 2019 22:28:17 GMT

ryan031581 on format pane, turn on +/- for matrix and you will get more or less the same experience

Re: Pivot table functionality

ryan031581 — Fri, 26 Jul 2019 13:41:35 GMT

Thanks, I'll have to check to see if that's a new feature. I'm not seeing it in the version for web server.

Version: 2.65.5313.1562 64-bit (January 2019)

Re: Pivot table functionality

ryan031581 — Fri, 26 Jul 2019 15:21:23 GMT

I don't see it in the July update

Re: Pivot table functionality

parry2k — Fri, 26 Jul 2019 15:28:50 GMT

ryan031581 what version you are using? It came out in nov 2018

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#expandCollapse

Re: Pivot table functionality

ryan031581 — Fri, 26 Jul 2019 15:30:40 GMT

I just got the latest version and it's not there.

Version: 2.71.5523.941 64-bit (July 2019)

Re: Pivot table functionality

parry2k — Fri, 26 Jul 2019 15:33:43 GMT

ryan031581 make sure you are using matrix visual.

Re: Pivot table functionality

ryan031581 — Fri, 26 Jul 2019 15:37:35 GMT

I am

Re: Pivot table functionality

ryan031581 — Fri, 26 Jul 2019 16:20:34 GMT

I found out it's not available with connections to SSAS. Microsoft, please get it working!

Thanks for your help.

Re: Pivot table functionality

parry2k — Fri, 26 Jul 2019 17:20:06 GMT

ryan031581 that was going to be my next question but you already figured it out. Anyhow. I guess this is somethig you want to put on ideas forum if doesn't exists already.

Re: Pivot table functionality

Anonymous — Fri, 26 Jul 2019 17:44:43 GMT

I have Azure Analysis Services as my data source and I do see the +/- option under row headers.

Is this expected?

Re: Pivot table functionality

parry2k — Fri, 26 Jul 2019 17:50:03 GMT

Anonymous tabular is fine but SSAS MD doesn't have that functionality.

Re: Pivot table functionality

ryan031581 — Fri, 26 Jul 2019 18:29:21 GMT

Thanks for information.