Highlight the Bar based on line chart values

[Balaraju]

Hi All,

I have one requirement i.e I have line chart showing that month wise promoter sales and Bar chart showing that top 5 Promoter Sales.

You can see below screenshot we have 3 promoters in line chart under store A and Top 5 promoters in bar chart, Promoter 1002 and 1003 are present under top 5 Prometer list in Bar chart.

  

Now the actual requirement is I want to see who so ever promoter reflecting in line chart and Bar chart should be highlighted with another color. you can see the below output image. 

Thanks,

Bala.

[Syndicate_Admin]

There @Syndicate_Admin ,

This is my test table:

Please try following DAX to create measures:

Sum of sales = SUMX(FILTER(ALL('Table'),'Table'[Promoter ID] = SELECTEDVALUE('Table'[Promoter ID])),'Table'[Sales])

Rank = RANKX(ALLSELECTED('Table'),[Sum of sales],,DESC,Dense)

Grey = IF(MAX('Table'[Promoter ID]) = "1002" || MAX('Table'[Promoter ID]) = "1003","Grey")

Create a line chart and put [Promoter ID] in filters like below image shown:

Create a stacked column chart and put [Rank] in filters like below image shown:

And then condinitional formatting for column's color:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Balaraju]

@Syndicate_Admin Thank you for your update, but it is not suitable for me, could you please check my table below I have different stores if i am going to select another store other promoters information is visible at line chart if the promoters in line chart is present top 5 promoters bar chart I want to see the grey color for bar.

Promoter ID	Store Name	Month	Sales
1001	A	Jan-22	100
1001	A	Feb-22	150
1001	A	Mar-22	250
1002	A	Jan-22	350
1002	A	Feb-22	250
1002	A	Mar-22	50
1003	A	Jan-22	300
1003	A	Feb-22	200
1003	A	Mar-22	50
1004	B	Jan-22	150
1004	B	Feb-22	250
1004	B	Mar-22	50
1005	B	Jan-22	300
1005	B	Feb-22	200
1005	B	Mar-22	50
1006	B	Jan-22	100
1006	B	Feb-22	150
1006	B	Mar-22	250
1007	C	Jan-22	300
1007	C	Feb-22	250
1007	C	Mar-22	50
1008	C	Jan-22	300
1008	C	Feb-22	200
1008	C	Mar-22	50
1009	C	Jan-22	350
1009	C	Feb-22	250
1009	C	Mar-22	150