Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
113 | |
69 | |
59 | |
46 |