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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
cgairik
New Member

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
Super User
Super User

@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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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