Forum Discussion
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
- AnonymousNot applicable
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 TeamIf 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!
- AnonymousNot applicable
Thanks for the reply but does not answer to my question.