Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Get the highlighted value

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

2 Replies