Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
CatEps
New Member

Need help creating visual grouping in Matrix chart

I;m trying to group my Accounts into categories (see excel sheet below to get general idea of goal). I've tried to create a category column in the data input, but then it just sums the totals by category instead of treating it a a header/label for the accounts

 

Grouping Goal.PNG

Currently this is what it looks like, some accounts will be unlabled but I don't mind just assigning them a third category.

Current Accounts.PNG

 

Any advice on how to make my visual have those indents?

1 ACCEPTED SOLUTION
sean_cochran
Resolver I
Resolver I

I would do the following:

 

  1. Make sure you're using the matrix visual (looks like you're using a standard table?)
  2. Add the "category" column as a row in the matrix
  3. Add the "accounts" column as the second row in the matrix (under "category")
  4. Add your measure/value to the "Values" are of the matrix chart
  5. Expand out the "category" column using the "+" signs next to each category in the actual visual
  6. Switch off "row subtotals" in the visual format settings for the matrix chart

This should get you close if I understand your problem. As a quick note, providing a sample file or at least some data helps with troubleshooting - makes it much easier to understand the issue and communciate about a solution.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @CatEps ,
As @sean_cochran  said, you can provide more details with your desired out put and pbix file without privacy information. However I tried to create an example and you can follow the steps below:
1.Create a measure

 

total = 
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Name] = SELECTEDVALUE ( 'Table'[Name] ) )
)

 

 

Final output:

vyifanwmsft_1-1707116932370.png

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

sean_cochran
Resolver I
Resolver I

I would do the following:

 

  1. Make sure you're using the matrix visual (looks like you're using a standard table?)
  2. Add the "category" column as a row in the matrix
  3. Add the "accounts" column as the second row in the matrix (under "category")
  4. Add your measure/value to the "Values" are of the matrix chart
  5. Expand out the "category" column using the "+" signs next to each category in the actual visual
  6. Switch off "row subtotals" in the visual format settings for the matrix chart

This should get you close if I understand your problem. As a quick note, providing a sample file or at least some data helps with troubleshooting - makes it much easier to understand the issue and communciate about a solution.

This was it! I was using a company template so it had the +/- icons turned off which is why I reached a standstill. Now that I've found that setting everything else falls into place. Much appreciated, will try to include files in the future.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.