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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
cho
Helper I
Helper I

Format alignment of rows in a table

Hi experts!

 

I need to add different alignments for each row in a PowerBI table. Example is like this:

cho_0-1676636057873.png

As you can see, in the column "Type" row values have different alignments. I tried this by using formating function in "cell elements", but there is no option to change the alignment.

Also, I need a table, NOT a matrix.

"Type"  is one column in the original table in the source. I know this is possible because I found a pbix containing this. Unforetunately I can't find the way the developer did it.

 

Appreciate your help!

1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

Hello @cho ,

 

You could try to define the levels in columns, check this video where he builds the hierarchy for a P&L statement, so you should learn how he did the hierarchy so you could do it for your case https://www.youtube.com/watch?v=IGCIsCC5iXQ

 

If I answered your question, please mark my post as solution, Appreciate your Kudos👍

 

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

1 REPLY 1
Idrissshatila
Super User
Super User

Hello @cho ,

 

You could try to define the levels in columns, check this video where he builds the hierarchy for a P&L statement, so you should learn how he did the hierarchy so you could do it for your case https://www.youtube.com/watch?v=IGCIsCC5iXQ

 

If I answered your question, please mark my post as solution, Appreciate your Kudos👍

 

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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