Forum Discussion
Post ProdigyExpand/Collapse Hierarchies in Tables/Matrix?
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!
15 Replies
SeanCommunity Champion
I've been asking for this since August 6, 2015
How to use DATEDIFF :smileywink:
- Phil_Seamark
Microsoft Employee
It's not possible yet. But I believe it is close. I understand a demo was shown at the recent UK Data Insights summit.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?
OneWithQuestionI 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 :(
- igorabdo
Advocate II
Hi Phil
Do you know if there is a solution or have you launched something to solve this problem?
- igorabdo
The both
