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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
rikabkothari
Frequent Visitor

Only the last row in the rows of a matrix should not be in bold.

I want to achieve something like below. Only the column of the rows in the matrix should not be in BOLD(In the below image BI - Change), all the columns above should be BOLD irrespective of expand all or collapse all.

 

Lets see we are using Column1,Column2 and Column3 in the rows of the Matrix. I want Column3 to be not in BOLD when the user Expand All.

 

Please help, it is very urgent

 

rikabkothari_0-1724230771820.jpeg

 

 

4 REPLIES 4
Anonymous
Not applicable

Hi @rikabkothari ,

 

Maybe you can try below formula to create measure and use it to conditional formatting:

IsNotLastRow = 
VAR LastRowValue = MAXX(ALL('Data'), 'Data'[ID])
RETURN
IF(MAX(Data[ID])< LastRowValue, "blod", "red")

vkongfanfmsft_0-1724396510073.png

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I dont see conditional formatting for rows. I need this changes in the rows only not the columns.

Anonymous
Not applicable

Hi @rikabkothari ,

 

Conditional formatting doesn't support acting on rows, plus in my tests it was applied to values instead of columns.

vkongfanfmsft_0-1724837972194.png

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

raji_n
Resolver II
Resolver II

@rikabkothari this is unfortunately not available in default matrix visual, try for json theme generator if that has an option to set up such settings.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.