Expand & collapse matrix row headers

February 10, 2019

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

 

We are very excited to announce the release of one of the most requested visual features, the ability to expand and collapse individual row headers.

 

There are two ways you can expand row headers. The first is through the right-click menu. You’ll see options to expand the specific row header you clicked on, the entire level or everything down to the very last level of the hierarchy. You have similar options for collapsing row headers as well.

 

 

 

 

You can also add +/- buttons to the row headers through the formatting pane under the row headers card. By default, the icons will match the formatting of the row header, but you can customize the icons’ color and size separately if you want.

 

Once the icons are turned on, they work similarly to the icons from PivotTables in Excel.

 

 

The expansion state of the matrix will save with your report. It can be pinned to dashboards as well, but consumers will need to open up the report to change the state. Conditional formatting will only apply to the inner most visible level of the hierarchy. Note that this expand/collapse experience is not currently supported when connecting to AS servers older than 2016 or MD servers.

 

Watch the following video to learn more about expand/collapse in the matrix:

 

 

 

 

 

 

 

 

 

 

Some opinions expressed in this article may be those of a guest author and not necessarily Analytikus. Staff authors are listed in https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#expandCollapse

Please reload

Featured Posts

Analytikus LLC y BEXTechnology S.A., nueva alianza en ciencia de datos, machine learning e Inteligencia Artificial.

May 8, 2018

1/4
Please reload

Recent Posts
Please reload

Search By Tags
Follow Us
  • Facebook Social Icon
  • Twitter Classic
  • LinkedIn Social Icon
  • YouTube Social  Icon
  • itunes

© 2019 by analytikus, LLC - Privacy Policy

us_1821_499x335.jpg
EN
España.png
ES
  • LinkedIn Social Icon
  • Twitter Classic
  • Facebook Social Icon
  • YouTube Social  Icon
  • itunes