Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Is there a way to display additional measures in the data labels in Pie or donut charts?

Hi all,

 

I am wondering if there is way to display Order count in the Pie or donut chart that is displaying the Order revenue sum? Example below.

 

PIc1.PNG

Thanks,

Gautham

2 REPLIES 2
v-cazheng-msft
Community Support
Community Support

Hi, @Anonymous 

If you want to display two data fields in one Pie chart or Donut chart, you can try this workaround.

 

1 Create a Calculated column

Qtr&Order_count =

'Table'[order date].[QuarterNo]

    & SWITCH ( 'Table'[order date].[QuarterNo], 1, "st", 2, "nd", 3, "rd", 4, "th" ) & " Qtr" & ","

    & CALCULATE (

        COUNT ( 'Table'[order date] ),

        ALLEXCEPT ( 'Table', 'Table'[order date].[Quarter] )

    )

 

2 Create a Pie or Donut Visual

v-cazheng-msft_0-1614648472193.png

 

 

The result looks like this:

v-cazheng-msft_1-1614648472198.png

 

Here is the pbix.

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

pranit828
Community Champion
Community Champion

Hi @Anonymous 

Right click on the values of the visual in the fileds tab and select count.

pranit828_1-1614450523853.png

Additionally, you can select the information you need displayed by seleting the Detail Lable in the Format tab.

pranit828_2-1614450585253.png

 





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.