Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello All
How to write expression when value is selected from filter/slicer then apply specific color code to column values only
for instance i'm selecting
1) State column value in slicer as Detroit, color code all different places/locations to Red color in columns.
2) State column value in slicer as Newjersy, color code all different places/locations to Blue color in columns.
Matrix :
Column : Location
Row : County
Measure: Population
Thanks
Rm
Solved! Go to Solution.
@RMRaptor , if you are not using legend and you are able to see fx icon on color, you will be able to use a color measure and use it conditional formatting using field value option
color = Switch(selectedvalue(Table[State]) ,
"Detroit", "Red",
"Newjersy", "Blue",
"Green"
)
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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...
@RMRaptor , if you are not using legend and you are able to see fx icon on color, you will be able to use a color measure and use it conditional formatting using field value option
color = Switch(selectedvalue(Table[State]) ,
"Detroit", "Red",
"Newjersy", "Blue",
"Green"
)
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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...
User | Count |
---|---|
63 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
41 | |
40 |