highlight and tooltip

[Hennry2344]

When I cross-filter my sales bar chart by country, I want to display the highlight of my bar chart by manufacturer but in percentage, normally Power Bi displays it in absolute values.

I created a measure and it works well when I put it on a table, but when I put it in the tooltip, it shows me 100%

Is there another way to achieve this result?
Thank you

[amitchandak]

@Hennry2344 , can you share the formula ?

[Hennry2344]

Here is the pbix > https://1drv.ms/u/s!AoIRa67hIHkpfZx9vq_vS8hmQcA?e=NPS3eg

[v-easonf-msft · Accepted solution]

Hi , @Hennry2344 

I didn't find any error in your formula.

I guess that  hightlight will not affect the  measure filed in tooltip.

As a workaroud,you can try to create a custom tooltip by using "text box" and the  "Card" visual.
And you need to modify the page backgroud color,tooltip page size,visual font size....

The result will show as below:

Please check the attached pbix file for more details.
pbix attached

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Hennry2344]

% Selected =

VAR TotalRevenue = CALCULATE(SUM(Sales[Revenue]),ALL(Sales), VALUES(Manufacturer[Manufacturer]))

VAR highlighted = CALCULATE(SUM(Sales[Revenue]), ALLSELECTED(Sales[Country]))

return

DIVIDE(highlighted,TotalRevenue )