Add expand/collapse feature to column headers
Vote on this idea if you want expand/collapse on column headers in the matrix similar to what was shipped for row headers in November (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#expandCollapse).
Mohammed Adnan commented
Yes. it will be very helpful
Hi Microsoft, any update on this extremely important improvement? Please really consider to add this little, but again, very important feature in Power BI. We need it!
Here are two very important benefits of Expand/Collapse Column Headers. It is Even better if we can just Hide (remove) them from the Viz like in TABLEAU":
* Enable you to use Dynamic Title freely.
* Enable you to Lock the sort order because users cannot click on the Headers if they are Collapsed or Hidden.
The Expand/collapse column is very useful, Please add it!
Iris Fung commented
‘Hide/ expand / collapse column’ is a very useful feature to add in, please add !!
Buy Cannabis online, Buy Weed online at our exotic cannabis shops and get free delivery
Buy pre-shred banknotes online
Buy counterfeit bills, ssd solutions..
Buy driver’s license online
Niranjan Gadre commented
Most of the account reports with date field as column header need drill down feature with collapse option(+/-). It will be great if matrix visual can have this option.
Yes agree this is critical ... in fact it is almost a decisive factor that make the customer to choose between PBI vs other tools in some cases.
Paul Ranschaert commented
Yes would be very helpfull to add this. I have In the month, year to date measures and 12 month rolling averages. For the YTD and 12 MRA you don't want to see every month but only the last month.
Dan robitaille commented
this would real help me
This is a critical requirement for many reports. please implement
Yes, please! Usually I face a matrix were in rows I have employees names and in columns the year/month/day...
I tried changing the order, but some offices has >30 employees so you can imagine the visual mess of searching them in the columns. In the same way, what I'm doing now it's to having employees in the rows and dates in the columns, but then when you expand to next level up to the day, now the visual displays all days (segmented in months) YTD, imagine what will happen to my matrix in a few more months! and if you are thinking about the filters, I have them, but as this matrix is part of a report showing other features, sometimes final users do not like to use the filters in order to see 'everything at a glance' ...
Agree with comment and it is realy necessary .....It would be great if column headers in the matrix can be expanded/collapsed the same way as for rows. Our finance users would like to show Year numbers in a column with ability to drill down to quarter, month level columns.
Ivan Georgiev commented
It would be awesome to have this feature!
Umar Ayub commented
Definitely need the + buttons on the columns really useful
Julia Fang commented
It would be great if column headers in the matrix can be expanded/collapsed the same way as for rows. Our finance users would like to show Year numbers in a column with ability to drill down to quarter, month level columns.
Rossitza Slavova commented
It is very important feature. I would like to be able to collapse and expand columns. For example: I would like to be able to show monthly values of a measure for previous months and see weekly values only for current month. Also conditional formatting should be applied to totals as well which is not the case currently. Can't you do it similar to excel and reporting services?
really need this feature to hide/collapse rows