Pie Chart Custom Data Label

[ChrisFromOhio]

Please help because I feel like this should absolutely be a thing in Power BI but I cannot seem to figure it out.

I need to create a pie chart with a data label that shows the category name, the % of total, and the % change of the value from the prior period. I have the % change value calculated as a measure and can display it in a tool tip, but cannot find a way to display it in the visual in the data label.

Is there any sort of way to do this, either through a standard visual or a custom visual? This feels incredibly basic but I cannot figure this out.

[ChrisFromOhio · Accepted solution]

Through a ton of trial and error using ChatGPT, I was able to get the visual I needed using an R script visual.

[samratpbi]

Hi @ChrisFromOhio as per my understanding, you cant add additional details in the data labels for pie chart to be displayed in the report. One option, you have already took, i.e. additional KPI into a tooltip. Another is, you can add a subtitle and add additional details. 

Another trick, if you really want to show additional details in the visual itself, without user hovering over the visual, is

1. create another pie chart

2. use the 2nd KPI

3. place the 2nd pie chart on top of 1st, then use some formatting like remove backgroud, change colors etc and place exactly on top of 1st one. Below is a screenshot.

Hope this will help to solve your problem. If it does, then please mark it as solution.

Thanks - Samrat

[ChrisFromOhio]

Hi @samratpbi - thank you for your reply. Unfortunately this isn't exactly visually appealing, and has other limitations as well. I'm going to leave this thread open for now in case anyone is able to suggest another visual that would be able to give me what I'm looking for.