Get the highlighted value

[Anonymous]

Hi everyone,

i have a stacked bar chart that rapresent hours by person (1) that highlight a 100% stacked bar chart (2) that rapresent all hours divided by categories.

I want to create a measure that rapresent the % of the category of the highlight name in 1.

How can i get the highlight value (the selected person) to calculate his hours (246 h)?

The result it would be: (246/510)*100 = 48,24%

Where 246 is the highlitghted value: the hours of the selected person of this particular category (246 h)
and 510 is the total hours of the category.

The % percentage returned automatically by power bi (in the highlighted value) is the hours of the selected person divided by ALL category %.

Thank you for the support

[Anonymous]

Hi @Anonymous ,

Do you want the tips in the chart to show the rate you want? If so, you can consider using the tooltip.

Customizing tooltips in Power BI Desktop - Power BI | Microsoft Docs

Using report tooltip pages in Power BI - Power BI | Microsoft Docs

Best Regards,

Gao
Community Support Team 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

[Anonymous]

Thanks for the reply but does not answer to my question.