Forum Discussion

EstherBR's avatar
EstherBR
Icon for Helper III rankHelper III
9 months ago
Solved

How to customize data label in a Donut chart

Hi,

 

Is it possible to customize the detail label in a donut chart? I would like to add the profit measure to the detail label.

 

 

 

 

Thanks!

 

Esther

  • Hello EstherBR ,

     

    what rohit1991 mentioned is not possible since the details field doesn't accept measures as you can see below, what I would suggest is to add the profit value as a tooltip and when they hover they can see it.

    of use field parameters so that they can switch in the donut chart between sales and profit .

     

    or use another visual that accepts a measure in the data labels like bar chart and then you can add the concatinated measure that he added in the data labels value.

     

     

     

    link for field parameters https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

     

7 Replies

  • Hi EstherBR 

    Unfortunately, donut chart labels cannot be customized in Power BI.
    Unlike bar/column charts (where you can build a concatenated label using DAX), donut/pie visuals only allow the built-in label options. Any additional information—like Profit—can appear only in the tooltip, not on the label itself.

    From a data visualization and UX perspective, this is actually a limitation of the visual itself:

    Donut charts are visually appealing but not effective for precise comparisons.
    Our eyes struggle to compare curved arc lengths, so it’s hard to judge which segment is bigger—there are even museum illusions demonstrating this.

    If you're trying to compare “part to whole” for a single category, a simple pie chart is clearer.

    If you need to compare multiple categories, a bar chart is always more readable and accurate. Even when the values are percentages, a bar chart makes the differences obvious because we compare lengths, not curves.

    If your goal is to emphasize one segment out of the whole, you can achieve it visually with a highlight/frame technique, similar to the image you showed—simply horizontal instead of vertical.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • Hi EstherBR 

    You can create a new measure that concatenates Sales + Profit into one text label, then place that measure in the “Details” field.

    Example DAX:

    Sales Profit Label =
    "Sales: " & FORMAT([Total Sales], "#,##0") &
    " | Profit: " & FORMAT([Profit], "#,##0")

     

     

     

     

    • EstherBR's avatar
      EstherBR
      Icon for Helper III rankHelper III

      Thanks rohit1991, Can you provide an screenshot of how you have don it. I do not  understand where you have added the the contactenated measure?

      • Idrissshatila's avatar
        Idrissshatila
        Icon for Super User rankSuper User

        Hello EstherBR ,

         

        what rohit1991 mentioned is not possible since the details field doesn't accept measures as you can see below, what I would suggest is to add the profit value as a tooltip and when they hover they can see it.

        of use field parameters so that they can switch in the donut chart between sales and profit .

         

        or use another visual that accepts a measure in the data labels like bar chart and then you can add the concatinated measure that he added in the data labels value.

         

         

         

        link for field parameters https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

         

  • No. Power BI does not currently allow you to customize the detail label in a donut chart as 'Details Well' does not support measure field. As u are willing to showcase the aggregated value in the 'Details well', it is simply not possible. U can workaround by showing Profit on hover using 'Tooltip' feature OR show Profit dynamically beside donut using smart narrative card.

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!

    Appreciate your Kudos!!

    Jaywant Thorat | MCT | Data Analytics Coach
    Linkedin: https://www.linkedin.com/in/jaywantthorat/

  • Thankyou, rohit1991Ritaf1983Jaywant-ThoratPhilipTreacy and Idrissshatila for your responses.

    Hi EstherBR,

    We appreciate your inquiry through the Microsoft Fabric Community Forum.

    We would like to inquire whether have you got the chance to check the solutions provided by Ritaf1983Jaywant-ThoratPhilipTreacy and Idrissshatila to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

    Thank you.