Grouping table rows based on values

[vishnukumar]

Hi,

I am new to PowerBI Desktop. I would like to group rows based on column values. Here I have given below example what I am trying to achieve. Can some one share me the step by step guiding document to do that.

Note : I have two separate table for County and City.

From :

Country	City
USA	New York
USA	Boston
USA	Atlanta
UK	London
UK	Manchester
UK	Birmingham
UK	Liverpool

To :

Country	City	Place	Open Hours
USA	New York	Central Park	10 AM
		Times Square	9 AM
		High Line	11 AM
	Boston	Fenway Park	10 AM
		XXX	1
		XXX	2
	Atlanta	YYYY	3
UK	London	A	1
		B	2
	Manchester	A	1
		B	2
		C	3

Grouping table rows

[PriyankaBhamare]

Hi @vishnukumar , 
These questions are similar to issue I'm facing. Please help me with linked question. Well, either power query editor or if there is any way to directly make it work in table visual, then let me know that too. 
(groupby function in power query editor - Microsoft Fabric Community)

Thanks. 

[CYParker]

This was a good solution for me until I added more "rows" than would fit on the screen and found I couldn't horizontal scroll 😞

[lokeshpatel]

Hi @CYParker 

Were you able to find a solution to your problem? When you added more "rows" than could fit on the screen? I tried to see if there was an alternative in table visual but I could not find one.

Thanks for any help!

[CYParker]

Hi @lokeshpatel 

I wasn't unfortunately. I stopped working on it and haven't gone back to it in recent times to see if another solution has become available

[Phil_Seamark]

Hi @vishnukumar

Which of your tables has the detail on the hours etc?

[vishnukumar]

Hi,

sorry for the delay. All fields like (Country, City, Place, Openhours) in a seperate tables.

Regards,

Vishnu

[vishnukumar]

Hi,

I am new to PowerBI Desktop. I would like to group rows based on column values. Here I have given below example what I am trying to achieve. Can some one share me the step by step guiding document to do that.

Note : I have two separate table for County and City.

From :

Country	City
USA	New York
USA	Boston
USA	Atlanta
UK	London
UK	Manchester
UK	Birmingham
UK	Liverpool

 To :

Country	City	Place	Open Hours
USA	New York	Central Park	10 AM
		Times Square	9 AM
		High Line	11 AM
	Boston	Fenway Park	10 AM
		XXX	1
		XXX	2
	Atlanta	YYYY	3
UK	London	A	1
		B	2
	Manchester	A	1
		B	2
		C	3

[Mbp]

Did this resolve your issue?

[Mbp]

Use the Matrix visualisation (it's in between the table and R script visuals).

[vishnukumar]

Hi,

When I am trying with Matrix, I canot see any rows are binding.

its only displaying country as first column and City is displaying as column header. 

Country	Newyork	Boston
USA

May I know exact step I need to follow or can you refer any video.

Regards,

Vishnu

[vishnukumar]

Hi,

Can some one guide me to do the Matrix Row Grouping ?

Regards,

Vishnu

[vishnukumar · Accepted solution]

Hi,

My problem resolved by using matrix and below tips.

"Once you have your values set in the row section of your matrix, go to your visualization. In the upper left, click the drilldown "Expand all down one level in the hierarchy" it is the right-side selection that forks. Click that until you get to the bottom level of what you want to see. Then go to the formatting option for the matrix, under "Row Headers" turn "Stepped layout" off.

That should list your matrix in a table style look while not repeating the valuse of the left side columns. "

Regards,

Vishnu

[JoseMoralesWCB]

This worked well!

[vishnukumar]

Hi Phil_Seamark,

Thanks for you suggestion. Database re-creation is going on, I will try with matrix and let you know soon.

Mean while, is there any sample, then please share.

Regards,

Vishnu