Forum Discussion
Helper IIIHighlight the Bar based on line chart values
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.
2 Replies
Syndicate_AdminAdministrator
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.
BalarajuSyndicate_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