cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Table Visualization - Group By Field?

My goal is to create a Table Visualization with a Group By structure, similar to how you can create a "Group By" in a SharePoint list.

 

Let's say I have a table of data as follow:

 

Make | Model | Color

Honda | Pilot | White

BMW | X5 | Black

Jeep | Cherokee | White

Toyota | Highlander | White

Volvo | XC90 | Black

 

The Make and Model columns are unique values, but the Color column is only White or Black. I want the table to appear as follows:

 

Black

BMW | X5

Volvo | XC90

 

White

Honda | Pilot

Jeep | Cherokee

Toyota | Highlander

 

I can't seem to find a solution that does this.

 

 

 

1 ACCEPTED SOLUTION

Try turning off "Stepped Layout" under "Row Headers" in your Matrix Visualization settings. Gets you pretty close to what you are looking for I think.

 

 

 

image.png

View solution in original post

5 REPLIES 5
Solution Specialist
Solution Specialist

Use the matrix visual and drop Color, Make and Model into the row bucket. Expand the visualization using the buttons in the top left of the visual. You will get this:

image.png

If you really want the "Toyota | Highlander" rather than the per row format you would need to create a calculated column in your data table that combines Make and Model.

I suspected you could only create the view I need with a calculated field. I played with the Matrix view prior to posting my question, and ended up with the cascading rows as you demonstrated.

 

Right now I have two seperate tables creating the view I want, and I just have them sitting next to each other. Was hoping to join them as one continuous table, but for what I need, I may just have to keep them as seperate visualizations.

Try turning off "Stepped Layout" under "Row Headers" in your Matrix Visualization settings. Gets you pretty close to what you are looking for I think.

 

 

 

image.png

View solution in original post

Resolver III
Resolver III

@mzeppieri

Out of my understanding you need black and white colors to be sorted.

 

Just drop the color column into a slicer and remaining two columns into a table. Select a value in the slicer then it will give you the res make and model.

 

 

The slicer option unfortunately will not work for me because I want to see all the tabulated data at once. Right now, I have two adjacent tables filtered to create the view I need, but I was hoping to create one table.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors