Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I am looking for a way to color a specific line based on selecting it and changing all other lines to gray. I've done this pretty easily in Tableau by creating a Set for the categorical 'Lot' which basically creates a group for selected ('IN') vs un-selected ('OUT') and then I can just drag that to the Color Card and when I select a line, it makes that selection a specific color, and the others gray.
Edit: here is an example of what I am talking about: https://www.youtube.com/watch?v=3m-taRT1Pko
Is this possible in Power BI? See below for some example data and image (remade in Excel) of what I'm looking for:
| Batch | Thaw Percentage | Intermediate Percentage | Culture Percentage | Day 3 Percentage | Day 6 Percentage | Day 9 Percentage | Day 13 Percentage | Pre-Formulation Percentage | Post-Formulation Percentage |
| A001 | 93 | 95 | 92 | 82 | 82 | 89 | 77 | 72 | 66 |
| A002 | 93 | 78 | 82 | 70 | 72 | 83 | 85 | 63 | 62 |
| A003 | 92 | 98 | 80 | 72 | 79 | 77 | 84 | 68 | 67 |
| A004 | 98 | 86 | 73 | 89 | 76 | 90 | 84 | 74 | 68 |
| A005 | 100 | 92 | 72 | 77 | 74 | 82 | 73 | 68 | 87 |
| A006 | 99 | 76 | 79 | 99 | 78 | 84 | 83 | 83 | 81 |
| A007 | 91 | 76 | 73 | 82 | 97 | 79 | 79 | 62 | 89 |
| A008 | 85 | 79 | 99 | 93 | 76 | 70 | 83 | 73 | 80 |
| A009 | 87 | 72 | 70 | 98 | 94 | 78 | 89 | 60 | 86 |
| A010 | 99 | 80 | 75 | 91 | 93 | 90 | 93 | 89 | 77 |
| A011 | 85 | 90 | 72 | 85 | 78 | 92 | 100 | 60 | 76 |
| A012 | 96 | 86 | 85 | 85 | 99 | 81 | 78 | 90 | 86 |
| A013 | 99 | 86 | 83 | 96 | 94 | 81 | 86 | 65 | 87 |
| A014 | 96 | 88 | 94 | 84 | 78 | 88 | 86 | 89 | 80 |
| A015 | 91 | 70 | 80 | 88 | 99 | 74 | 81 | 80 | 76 |
| A016 | 99 | 84 | 70 | 76 | 71 | 77 | 96 | 88 | 80 |
| A017 | 90 | 96 | 70 | 88 | 78 | 83 | 75 | 61 | 68 |
| A018 | 98 | 96 | 76 | 72 | 76 | 78 | 73 | 87 | 87 |
| A019 | 95 | 99 | 83 | 93 | 83 | 79 | 76 | 83 | 77 |
Solved! Go to Solution.
Hi @Janaya1
Unfortunately, there is no generic way to achieve this , because we don't have an option of conditional formatting of a line color.
There is an idea about this issue, please vote for it :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=bf62a5fa-d376-ed11-a76e-281878bd0909
But there is a few workarounds to achieve the desired effect in other ways.
Please refer to the attached links:
https://www.youtube.com/watch?v=_GOIflxSlYI
https://www.youtube.com/watch?v=rldduQrW83Q
https://www.youtube.com/watch?v=8RzZppthNPk
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @Janaya1
Unfortunately, there is no generic way to achieve this , because we don't have an option of conditional formatting of a line color.
There is an idea about this issue, please vote for it :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=bf62a5fa-d376-ed11-a76e-281878bd0909
But there is a few workarounds to achieve the desired effect in other ways.
Please refer to the attached links:
https://www.youtube.com/watch?v=_GOIflxSlYI
https://www.youtube.com/watch?v=rldduQrW83Q
https://www.youtube.com/watch?v=8RzZppthNPk
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
thank you!
Happy to help 🙂
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 64 | |
| 51 | |
| 46 | |
| 23 | |
| 19 |
| User | Count |
|---|---|
| 136 | |
| 110 | |
| 50 | |
| 32 | |
| 29 |