Tooltip showing all values in both bars within clusters in clustered column chart

[souvik900766]

Hi !

I have a clustetred column chart, where in axis I have used Pack size and Pack size sku and in Values Product A and Product B made out of two measures, for e.g.

Product B = CALCULATE(SUM(Data[Value]),Data[03 Brand]="Product B").
Now in the chart I want to add Mix% by using tooltip, the tooltip number is coming correct 
but
in both bars of the cluster I am seeing both Product A and Product B value together on hover....
I want to see Product A on hover of product A and Product B on hover of product B.

Thanks in advance !

[amitchandak · Accepted solution]

@souvik900766 , is a product on-axis or legend?

Only when it is on-axis or legend you can see the separate values.  Else you can create a tooltip page to show split on tooltip

https://docs.microsoft.com/en-us/power-bi/desktop-tooltips