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

View all the Fabric Data Days sessions on demand. View schedule

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