Forum Discussion
Unable to set data colors to transparent or use function/rule/field in bar chart visual
Hello,
I recently updated to Power BI September 2022 and I am unable to set bar colors or data colors to transparent or use any sort of function/field value/rule to display colors. When creating bar charts and pie charts I can assign specific colors using a dropdown but using #FFFFFF for transparent does not work. Does anyone know how to get around this issue?
Thank you!
Hi, B_VanderP
You can try the following methods.
Original:
Color = IF(SELECTEDVALUE('Table'[Date])=DATE(2022,1,3),"#FFFFFF00")Result:
You can use measure to set conditional formatting.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
B_VanderP , the transparent color is #FFFFFF00
and for that is a measure and use that in conditional formatting using the field value option
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/1682539 
v-zhangtiCommunity Support
Hi, B_VanderP
You can try the following methods.
Original:
Color = IF(SELECTEDVALUE('Table'[Date])=DATE(2022,1,3),"#FFFFFF00")Result:
You can use measure to set conditional formatting.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
