Forum Discussion
Customizing data labels
I'm trying to replicate the chart below in Power BI. I need the height of the bars to match the count, but would like the data labels to reflect the percentage of eac
Hi Anonymous ,
Sorry for my previous misunderstanding.
I understand now, you want the y-axis to display the values, and the data labels to show the percentages.
This is not possible at the moment, but I recommend you try the tooltips function, which can display both values and percentages, as long as you place the mouse in the corresponding position.
As a workaround, you can still set the display values on the y-axis, the data labels are still values, and you can additionally add the percentage you want in the tooltips.
Tooltips are an elegant way of providing more contextual information and detail to data points on a visual. Please refer to
Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn
Or even you can add a tooltip page in a visual. Please refer to
Create report tooltip pages in Power BI - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
Power BI has just introduced Custom Label for data labels. I think it will solve the problem.
Hi Anonymous ,
You may need to create a separate measure and then calculate the values grouped by Legend and x-axis separately and the values by x-axis only, respectively, to get the percentage.
Measure = VAR _sum = CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALLSELECTED ( 'Table' ), [Legand] = MAX ( 'Table'[Legand] ) && [Quarter] = MAX ( 'Table'[Quarter] ) && [Year] = MAX ( 'Table'[Year] ) ) ) VAR _total = CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALLSELECTED ( 'Table' ), [Quarter] = MAX ( 'Table'[Quarter] ) && [Year] = MAX ( 'Table'[Year] ) ) ) RETURN DIVIDE ( _sum, _total )Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.