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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
cgairik
Regular Visitor

Grouping not Working in power bi tabular visual

Hi,
Have dataset like below. I want to show this tabular data by grouping this wrt column A and B.
in default tabular visualization ,it does not appear like that.
by matrix visual we are getting such view, fields are added in rows. with the condition : in Row header.

cgairik_2-1696324728472.png

cgairik_0-1696325563345.png

 

 

 But when ever any new cataegory and sub category are coming those data are not showing , as those are not getting expanded .


Data:

cgairik_0-1696323869930.png

Visual Matrix:

cgairik_1-1696324666968.png

With new data addition:
data:

cgairik_3-1696324987926.png

Visual: in the marked area data are not getting expanded automatically.

cgairik_4-1696325066576.png

 

1 ACCEPTED SOLUTION

@cgairik , use "at the lowest level of data" button.

ChiragGarg2512_0-1696332012725.png

 

View solution in original post

6 REPLIES 6
ChiragGarg2512
Solution Sage
Solution Sage

@cgairik Use the Refersh button in Home Tab beside Transform data.

ChiragGarg2512_0-1696330079828.png

 

Sandhya1234
Helper II
Helper II

Need to refresh the data in power Bi Desktop or Power Query then only data gets updated in the table.
Before

Sandhya1234_0-1696329112555.png

After entering the new data.(After Refresh)

Sandhya1234_1-1696329155395.png

 

Hi,
It was already refreshed thatswhy F value is added under the category section. but it is not getting auto expanded. means without clicking that +/- sign on the data . 
And If I disable +/- button option that is not also expanding the data automatically in the other columns . 

Hi,
It was already refreshed thatswhy F value is added under the category section. but it is not getting auto expanded. means without clicking that +/- sign on the data . 
And If I disable +/- button option that is not also expanding the data automatically in the other columns . 

@cgairik , use "at the lowest level of data" button.

ChiragGarg2512_0-1696332012725.png

 

Thanks It worked

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors