Showing results for 
Search instead for 
Did you mean: 
Yashwant Frequent Visitor
Frequent Visitor

Formatting and Grouping of Data in Power BI

I have developed a tabular report in Power BI Desktop using power query. I need to do various formatting like background color of cell on basis of condition as we do in excel using conditional formatting but I didn't find any tab related to custom formatting . Also need to apply row grouping on table as can be done in power pivot table.  

We have developed a similar report in excel using power pivot table and have applied custom formatting in that.


Can you please help in achieving the similar visualization as we have done in Excel.


Excel Power PivotPower Dashboard Report.png




Super User
Super User

Re: Formatting and Grouping of Data in Power BI

There is a "matrix" visualization that should give you your grouping.


Nothing that I know of yet that allows formatting of pretty much anything.

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 211 members 2,190 guests
Please welcome our newest community members: