Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

PowerBI_ Dynamic color selection as per Geo

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 To...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous 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

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      Anonymous 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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thank you!! Parry.