scatter plot color formatting of bubbles in drill through as well

[Anonymous]

Hello @amitchandak @AlexisOlson 
Iam working on scater plot where iam using 2 columns in the values pane one at enterprise level and the other column is at region level. Info - Both the columns are coming from different tables

Enterprise Table	RegionTable
Enterprise 01(RED)	India
Enterprise 02(BLUE)	Canada
Enterprise 03(Green)	US
	ASIa
	europe

I need to condition format the bubbles with respect to the enterprise  all the regions assioated with Enterprise 01should be in red color and same way enterprise 02 with blue color like wise same
Can anyone please suggest how to do conditional formatting so that i i drill down through next level also the colors should change based on enterprise level.
Its urgent

[AmiraBedh]

You can create a measure that returns the enterprise name for each data point in your scatter plot.

Enterprise = RELATED(EnterpriseTable[Name])

Then create a new rule in the conditional formatting based on rules by selecting the measure in the field value.

You can set the min and the max values to 0 and 1, respectively and for each rule, you can set the color for each entreprise.

This should apply the desired color to each bubble based on the enterprise name. If you drill down to a lower level, the colors should still apply based on the enterprise name associated with each data point.

[Padycosmos]

Though on an unrelated topic, this video would help you to create a measure for conditional formatting:

https://www.youtube.com/watch?v=7veYU1EeO6w

[Anonymous]

This is not working, i have multiple enterprises,
Can you please try a different approach through measures

[AmiraBedh]

Can you provide a sample of your output ?