- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Expanding and collapsing values in a matrix
Hello,
I have a matrix in Power Bi that has rows by a certain category and column as another category as well. And then i have 4 measures in my values.
Is there a way to show only one measure and then collapse the rest?
The matrix is hard to read with all four measures. It would make it easier if they just saw the most impartant measure and if they need more details they can expand and see the other measures.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @VOx15 ,
Sorry for that only the outermost field will have (+) (-) signs. The sign only show in the left.
So we create the slicer to control the Measure which you want to show.
Or you can put the measure column to first row, but we think it is not what you want.
Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner : https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @VOx15 ,
Sorry for that only the outermost field will have (+) (-) signs. The sign only show in the left.
So we create the slicer to control the Measure which you want to show.
Or you can put the measure column to first row, but we think it is not what you want.
Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner : https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@VOx15 , Collapse of measure is not possible unless you convert them into dimension values.
An approach like this topic in the past:https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
or you can create a measure slicer https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You can add +/- expander to crosstab rows, but can't add it to crosstab columns.
Would bookmarks help in your case?
You can create one main crosstab with main measure and add a button besides. Clicking on this button detailed crosstab (with all measures) will "replace" main crosstab. And on this new view you will add another button which can return users to main crosstab.
Crosstab has option to drill down/up, but using bookmarks you can make it much more convenient for use.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I still need to show the main cross tab. Currently have the matrix set up like this, where the values show on rows
I would like to only show measure one then have a + to show the rest of the measures. Is that possible?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @VOx15 ,
We need to create a measure table and a new table, then create a measure to meet your requirement.
1. Create a measure table using Enter Data.
2. Then create a new table using crossjoin function.
Table 2 = CROSSJOIN('Table','Measure Table')
3. At last, we can create a measure and put it in Values in a matrix like the following screenshot.
Measure =
SWITCH(
TRUE(),
MAX('Table 2'[Column1])="Measure 1",CALCULATE([Measure 1],FILTER('Table','Table'[City]=MAX('Table 2'[City]) && 'Table'[Town]=MAX('Table 2'[Town]))),
MAX('Table 2'[Column1])="Measure 2",CALCULATE([Measure 2],FILTER('Table','Table'[City]=MAX('Table 2'[City]) && 'Table'[Town]=MAX('Table 2'[Town]))),
MAX('Table 2'[Column1])="Measure 3",CALCULATE([Measure 3],FILTER('Table','Table'[City]=MAX('Table 2'[City]) && 'Table'[Town]=MAX('Table 2'[Town]))))
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Yes! I was looking for something like that. Is there a way to have the (+ ) and (-) sign next to the measures instead of the city?
@v-zhenbw-msft

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-08-2024 07:38 PM | |||
07-19-2024 07:45 AM | |||
07-01-2024 06:47 PM | |||
05-28-2024 11:01 AM | |||
09-23-2024 09:46 PM |
User | Count |
---|---|
141 | |
115 | |
83 | |
63 | |
48 |