Create Subgroups in Power Bi Table Visualizations

[elcamino]

Hello  everyone,

Is it possible to make this in a table (not a matrix) visualization in power BI.

Thank you very much

[rohit1991]

Hi @elcamino ,

Yes, it is possible to create subgroups in a Power BI Table visualization while maintaining a structure similar to the one in your image. However, since Power BI’s Table visualization does not support hierarchical grouping like the Matrix visualization, you need to follow these steps:

 

1. Use a Custom Sorting Column:

Since Table visuals do not allow natural hierarchical grouping, you should create a Sorting Column in Power BI to structure the data properly.

1. In Power BI Desktop, go to Power Query Editor.
2. Add a custom column for sorting, for example:
   • "Chicago-USA-IL"
   • "New York-USA-NY"
3. Sort the table using this column to ensure a structured display.

2. Use DAX to Create Custom Headers:

Since Table visuals do not allow hierarchical column grouping, you need to create separate columns manually:

Use DAX to create calculated columns like:

Rent_Prices_2025_Index_New = IF( [Year] = 2025, [Index_New], BLANK() )
Rent_Prices_2025_Index_Old = IF( [Year] = 2025, [Index_Old], BLANK() )
Rent_Prices_2024_Index_New = IF( [Year] = 2024, [Index_New], BLANK() )
Rent_Prices_2024_Index_Old = IF( [Year] = 2024, [Index_Old], BLANK() )

3. Use Conditional Formatting to Differentiate Sections

• Go to Format Pane → Field Formatting → Apply background colors to differentiate sections (like Geography & Rent Prices). Use a light gray background for Geography columns and a different shade for Rent Prices columns.

4. Enable Word Wrap & Adjust Headers

• Enable "Word Wrap" in column headers under Formatting Pane.
• Rename columns accordingly to match the format of your original table.

Limitations & Alternative Approach

• Since Table visualization does not support column grouping, this method requires manual column creation.
• A Matrix visual would be a better alternative if you need true hierarchical grouping.

[danextian]

Hi @elcamino 

It is not possible to merge cells vertically like you've done for Geography.  Those in the values section are possible.

[Ritaf1983]

Hi @elcamino 
Unfortunately, we don't have an option for cell merging in visualization, only grouping based on logic and hierarchy, which is only possible in matrixes.
There is an idea about this issue, please vote for it ( I voted):
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=dd31f678-89ad-eb11-89ee-281878bdee4b

If my answer was helpful please give me a Kudos and accept as a Solution.