Frozen Columns in a Matrix?

Question

Hi Community,&nbsp;Is it possible to add another column into a matrix that remains static/frozen?In the example below, can I have Column A and B remain static, with C/D/E/F changing?Column A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column FSKU Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UPC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CY Units&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CY Revenue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PY Units&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PY RevenueKraft Smooth Peanut Butter 1KG&nbsp; &nbsp; 68100084245&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$200&nbsp;&nbsp;Or is this something I can only achieve via a Table?All other drill downs of the Matrix hierarchy works perfectly.&nbsp;&nbsp;

anonymous · Answer

You can do this via a Matrix.&nbsp; Put those fields into the "Row" box.&nbsp; You might need to press the 'Expand all down one level' button for each one you wish to display.&nbsp; I also recommend going into the Visual Format (paint roller icon) and going into 'Row Headers' and turning off 'Stepped Layout'

anonymous · Answer

Thanks Ross73312.I've followed all those steps and I get something that looks like this, even after turning off 'Stepped Layout'.Column A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column B&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column FSKU Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UPC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CY Units&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CY Revenue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PY Units&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PY RevenueKraft Smooth Peanut Butter 1KG&nbsp; &nbsp;&nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;68100084245&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$200&nbsp;If I proceed to turn off 'Row subtotals' within the Subtotals, I get something like this, more of what I'm looking for.Column A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column B&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column FSKU Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UPC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CY Units&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CY Revenue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PY Units&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PY RevenueKraft Smooth Peanut Butter 1KG&nbsp; &nbsp;&nbsp;68100084245&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$200&nbsp;Is there a way to turn on subtotals only for specific Rows and want it to apply to the first Nut Butter row?For example, my rows in my Matrix are : Nut Butters, SKU Name, UPC

anonymous · Answer

Not for specific rows, no.

v-danhe-msft · Answer

Hi&nbsp;Anonymous,
Basd on my test, I am afraid you could not achivev this feature, I suggest you&nbsp;submit an idea in Ideas forum:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
&nbsp;
Regards,
Daniel He

azharuddin10 · Answer

Yes you can enable/disable subtotals for row level heirarchy.Step1: Go to the heirarchy level that you want to disableStep2: Now, Go to Subtotals sections in FORMAT Pane.Step3: Now you will see option to disable that particular row level subtotal( by default all subtotals are Enabled)&nbsp;This way you can Enable or Disable any level Row Subtotals&nbsp;

Forum Discussion

Frozen Columns in a Matrix?

5 Replies

Related content

Frozen Pages

Matrix Column Widths

Matrix column based on other matrix columns

Matrix column not grouped

Matrix table column Hide