Unable to set data colors to transparent or use function/rule/field in bar chart visual

[B_VanderP]

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! 

[v-zhangti · Accepted solution]

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.

[amitchandak]

@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/...