cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Grouping of dynamic values in Pie chart

Hello all,

I am stuck in some weird dilemma with some not so friendly pie chart data set.

I have a data set based on survey questions and values. Survey contains 25questions and each has a text value answer. My team wants to showcase one particular question in that survey in form a pie-chart only. As it is survey, some answers have high entry rate than others. For e.g.
User 1 - Question 4- Not interested to disclose
User 2- Question 4: >35000
User 3-Question 4: >5000 and so on

Now when I am creating pie-chart for Question 4, values like "Not interested to disclose" take up 32% of pie, some other value take 15%, whereas values such ">35000" take up only 2% pie area. These values get squeezed and difficult to select. The scenario mentioned at last occurs for 8 kind of responses with all taking something between 5% to 0.7% of pie area. Like I mentioned before, all these 8 values are difficult to view or select. Showcasing top N is not helpful as all values are important from business perspective.

So is it possible we can dynamically group all these low hanging values in one as "Other"? And then use tool tip or some other bookmark method to showcase the small values in form of bar chart? Zoomcharts donut chart was not helpful because of watermark.

Also can we show legends as "Not interested to disclose- 35%" instead of just 35%?

Thanks for your help.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Grouping of dynamic values in Pie chart

Hi,

 

According to your description, i create a sample to test:

90.PNG

Then please try to create a column to show new type:

NewType = IF(CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Type]))/COUNTROWS('Table')<=0.1,"Other",'Table'[Type])

Choose pie chart, it shows:

91.PNG95.PNG

Then create a new page, choose [Type] as Pie chart, and apply a filter to it, it shows:

92.PNG

Turn on DrillThrough function:

93.PNG

When you choose 'Other' type in the first page, you can drill through to see its details:

94.jpg

Here is my test pbix file:

pbix 

Hope this helps.

 

Best Regards,

Giotto Zhi

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Grouping of dynamic values in Pie chart

Refer :https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Re: Grouping of dynamic values in Pie chart

Hi,

 

According to your description, i create a sample to test:

90.PNG

Then please try to create a column to show new type:

NewType = IF(CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Type]))/COUNTROWS('Table')<=0.1,"Other",'Table'[Type])

Choose pie chart, it shows:

91.PNG95.PNG

Then create a new page, choose [Type] as Pie chart, and apply a filter to it, it shows:

92.PNG

Turn on DrillThrough function:

93.PNG

When you choose 'Other' type in the first page, you can drill through to see its details:

94.jpg

Here is my test pbix file:

pbix 

Hope this helps.

 

Best Regards,

Giotto Zhi

View solution in original post

Highlighted
Frequent Visitor

Re: Grouping of dynamic values in Pie chart

v-gizhi-msft - Great solution. Thanks your help along with PBIX file. You are the best!

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors