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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have to create a bunch of charts with crop data. There are a lot of different crops and I need to create a lot of differnet charts. Particularly pie charts. Currently it seems I have to manually go through and change every value to the correct color based on what it is. Is it possible to define a macro or something that will set the color based on the legend key? Right now I only see theme, but I don't want the first 8 to have the same value every time. I want corn to always be yellow, cotton to always be white, watermelon to always be green, etc. No matter where in the data set it falls. See link for image
@Anonymous ,
As far as I know, it is not yet supported. You may submit an idea via https://ideas.powerbi.com/forums/265200-power-bi.