SCATTER PLOT LEGNED COLOUR SHOULD BE STATIC

[Anshenterprices]

HI TEAM 

SOURCE DATA

Universitycode	CollegeName	Category	subCategory	EduCategory	revenue	cost	Date
A1	Cape Town	HigherEducation	HigherEducation	HigherEducation	120	45	19/7/2021
A2	Cape Town	Masters	Masters	Masters	121	23	19/7/2021
A3	Pretoria	HigherEducation	HigherEducation	HigherEducation	122	66	19/7/2021
A4	Pretoria	Masters	Masters	Masters	123	53	19/7/2021
A5	Witwatersrand	Higher	Higher	Higher	124	67	19/7/2021
A6	Witwatersrand	Masters	Masters	Masters	125	34	19/7/2021
A7	Rhodes	HigherEducation	HigherEducation	HigherEducation	126	56	19/7/2021
A8	Rhodes	Masters	Masters	Masters	127	86	19/7/2021
A9	Mansoura	HigherEducation	Bachlers	Bachlers	128	79	19/7/2021
A10	Mansoura	HigherEducation	PHD	PHD	129	69	19/7/2021
A1	Cape Town	Masters	Masters	Masters	120	66	19/7/2021
A2	Cape Town	HigherEducation	HigherEducation	HigherEducation	123	53	19/7/2021
A3	Pretoria	HigherEducation	Ecommerce	Ecommerce	124	67	19/7/2021
A4	Pretoria	HigherEducation	HigherEducation	HigherEducation	125	34	19/7/2021
A5	Witwatersrand	Masters	Masters	Masters	126	56	19/7/2021
A6	Witwatersrand	HigherEducation	HigherEducation	HigherEducation	127	86	19/7/2021
A7	Rhodes	Masters	Medical	Medical	128	79	19/7/2021
A8	Rhodes	HigherEducation	HigherEducation	HigherEducation	129	23	19/7/2021
A9	Mansoura	Masters	Masters	Masters	128	66	19/7/2021
A10	Mansoura	HigherEducation	Hotelmangment	Hotelmangment	129	53	19/7/2021

OUTPUT

SCATTER PLOT:- LEGEND- EduCategory
X Axis- cost
y axis - revenue
date slicer
university code slicer


once use selects any university code it shold change the scatter plot based on the legend

but user need green and red colour for the legends and it should be fix it means that if category value = educategory value then colour should be green else sub category value = educategory value then colour shouold be red


i am not able to set colour of legend power bi takes different after any other univerversity id selection



Thanks

[amitchandak]

@Anshenterprices , as of now we can not use conditional formatting once legend is used.

keep that on-axis and try conditional formatting, if they are more than one, use expand icon to expand

create a color measure and use that in conditional formatting using field value option

if( [category value] = "educategory", "green", "red")

refer if needed

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[Anshenterprices]

@amitchandak if possible please share pbix file?

[Anshenterprices]

@amitchandak  but there is no any option for conditional formatting