I need help regarding the color formatting in the PowerBI desktop. In my dataset, I have Geos, Countries, Customers, and Sales with those fields I created a new Measure (called as Sales of Top5) for the Top 5 Customers. With the Top 5 measure and Customers, I created a Clustered column chart as shown below. What I want to visualize is: if I filter the GEO on the page it should show the Customer color as per Geo selected.
Let suppose if I filter GEO to America, on the Clustered chart it should show America related Top 5 customers and color should be America related color (if I give red color to America it should show the data bar color as RED). If I select Asia it should the Top 5 customers of ASIA and color should be ASIA related color (if I give BLUE color to Asia it should show the data bar color as BLUE). At present, it is showing the same color in all countries. Any suggestions or help?
Solved! Go to Solution.
@ta5656 you can use conditional formatting for color, add new measure for color
Color = SWITCH( MAX( Table2[Geo] ), "Asia", "Blue", "Europe", "Green", "America", "Red" )
go to format painter, click dots on data color, and select conditional formatting
on conditional formatting, select field value and then select name of your measure we create color and you will see your bars color will based on the geo selection.
First of all, thanks for your response, Parry.
But, I forgot to mention, I want to implement this in Power BI August 2018 version, in this version condition formatting is not available. Is there any alternate way to do this?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.