PowerBI_ Dynamic color selection as per Geo

[ta5656]

Hi,

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?

Thanks!!

[parry2k]

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

[ta5656]

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?

Thanks!!

[parry2k · Accepted solution]

@ta5656 that is painful, I'm sure there is reason that you cannot use most recent version, drop Geo on Columns and then you can change the color by geo

[ta5656]

Thank you!! Parry.