Expand/Collapse Hierarchies in Tables/Matrix?

[OneWithQuestion]

In Excel, SSRS, etc... you can easily use a hierarchy and it will make the table/matrix expandable with little + and - buttons:

Is there still no way to accomplish this with Power BI?

For some reason I was thinking this functionality had been added, but I am not seeing it.

Is it really still impossible to do expand/collapse on simple hiearchy like sales regions or product categories, etc...?

Thanks!

[kaisrec]

https://community.fabric.microsoft.com/t5/Desktop/collapse-all-and-expand-all-functionality-over-a-b...

[Anonymous]

Same issue here. It is possible to expand all, but is it already possible to open just one node? Thanks a lot!

[igorabdo]

The both

[Anonymous]

Can you tell me how you can expand just one node please?

Thanks a lot!

[igorabdo]

Today isn't possible.

It will be in October release

[tjd]

Perhaps I'm missing something, but you can do this in the current matrix visual using drilldown.  And, it's more powerful as you can drill down/up by levels, nodes, or, levels and nodes - by rows or by columns.  It's just not as intuitive as having the "+" and "-" buttons next to each row.

[Anonymous]

Hi tjd,

Can you show us how? Just one node, not all of them? I can drill down one level, but than all of the nodes will expand...

Thanks a lot!

[tjd]

Clicking on the drilldown arrow on the far right activates "cell" drilldown.  With the arrow activated (dark), you can then click on a row cell header and it will drill down on just that cell to the next level.  Click a cell again and it will go to the next level for just that cell.  Pretty slick!  Hope this helps.

[Anonymous]

Hi tjd

I see what you mean. This can fix the problem already a little bit. Thanks! 

Indeed not that user friendly and all the other "high levels" are not visible anymore, but OK for now 🙂

Thanks a lot!!

[Sean]

I've been asking for this since August 6, 2015

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-bu...

How to use DATEDIFF

[Phil_Seamark]

It's not possible yet. But I believe it is close. I understand a demo was shown at the recent UK Data Insights summit.

[igorabdo]

Hi Phil

Do you know if there is a solution or have you launched something to solve this problem?

[JAkerblom]

@Phil_Seamark, I really hope you're right because this really is a huge deal for so many in whether or not to even use Power BI in ones organisation. It's embarrassing trying to explain to old Excel'ers that a trivial feature like this isn't possible when wanting to shift from stale Excel reports to dynamic PBI-reports. "Why would I want to use Power BI when I can do all it can do and much more in Excel?"  .... 

Do you by any chance have any link or update on this matter?

[OneWithQuestion]

I am in the exact same boat... Lots of Excel users but PBI can't host Excel with a data connection to SSAS Tabular model and it can't replicate basic pivot table functionality... Show stopper for us 😞

[v-qiuyu-msft]

@OneWithQuestion@OneWithQuestion As you can see from the idea @Sean posted, this feature is Under Review. Let's keep vote it up to make PG prioritize this feature. I will also report this feedback internally.

Best Regards,
Qiuyun Yu