Forum Discussion
Helper IExpanding and collapsing values in a matrix
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.
Helper II 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?
Community SupportHi 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.
- VOx15
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