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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Erburi92
Frequent Visitor

How to select one row from the table and change color with different button

Hello,

 

I need your help:) 

 

I would like to know if it is possible to do something like that (see the image as it is excel) in power bi. I have a table with information in different rows. I check every row manually by clicking on buttons (reviewed, under_review, and so on). Firstly, I select the row and click on a particular button. Then the row is colored with a specific color (it is done with macros). Can I do the same in power bi?

I know there are no macros and VBE, however, maybe there is another way how to do it?

Thank you:)


excel.PNG

3 REPLIES 3
amitchandak
Super User
Super User

@Erburi92 , Based on what get. Power Bi can not color a row. So you need do conditional formatting for all values/fields.

 

You need an independent table for slicer once you select that value you can use conditional formatting using field value option

 

Color Meausre =

if(Max(Table[Column]) = selectedvalue(Table[Column]) , "Yellow", "White")

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you.

 

However, if I need to select just one row and color just it, others should be without color, could I use your suggestion as well? Because I need to color each row independently, I can not select several rows at one.  So I would need to use conditional formatting every time?

 

Many thanks:)

 

Thank you @amitchandak 

 

However, if I need to select just one row and color just it, others should be without color, could I use your suggestion as well? Because I need to color each row independently, I can not select several rows at one.  So I would need to use conditional formatting every time?

 

Many thanks:)

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Kudoed Authors