Expanding specific values in a matrix

Question

I have a matrix with customer data as a dimension, I aggregate my values by these dimensions.&nbsp;My customer data consists of two values, customer name and customer group.&nbsp;So &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; customer 1 is in group 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; customer 2 is in group 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; customer 3 is in group 2 etc.&nbsp;&nbsp;In the rows of the matrix I want to show group one expanded and group 2 not expanded.&nbsp;So I want to see:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; customer 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; turnover of customer 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; customer 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; turnover&nbsp;of customer&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; group 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; turnover&nbsp;of&nbsp;group 2&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; Total Turnover.&nbsp;Could anybody help me out?&nbsp;

v-piga-msft · Accepted Answer

Hi Binkhorst，&nbsp;By my test, there is no option to directly show group 1 expanded and group 2 not expanded in Power BI. &nbsp;This feature is not supported currently. You could vote this&nbsp; similar idea here which has been submitted in Power BI ideas forum.&nbsp;Best Regards,Cherry

Forum Discussion

Expanding specific values in a matrix

2 Replies

Related content

Fabric Notebook ExitValue how to select specific values

Specific values in a slicer

expanded table

Specific matrix

Expanding table in Power Query - preview shows correct value, but after expanding its incorrect