cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
anchal5335 Helper I
Helper I

How to show detailed Labels (% and count both) for clustered column chart visualization?

Hello,

 

I am a newbie to Power BI. I was just wondering if there is any to show both the % and count value with category name in data labels of clustered column chart visualization?

 

I can see that option for a pie-chart and a donut wherein you can show detailed data labels (%, count and category name) ? Can the same also be achieved in other visualizations particularly clustered column chart because as per my understanding I can see that either it shows the count or % value but not both!

 

Any help would be greatly appreciated!

 

Thanks

Anchal

1 ACCEPTED SOLUTION

Accepted Solutions
Seward12533 Solution Sage
Solution Sage

Re: How to show detailed Labels (% and count both) for clustered column chart visualization?

For the pie chart you need to make it bigger or try another visual.  If you don't mind ads or can pay for the pro version the Drill Down Donut chart is very slick.  I will also do 100% Row or Columns charts instead of PIE charts. 

 

For the labels if you make the 2nd Y Axis MAX 1000% it will force all the labels to be at the bottom as I demonstrated.

 

capture20180719153930719.png

View solution in original post

8 REPLIES 8
Super User III
Super User III

Re: How to show detailed Labels (% and count both) for clustered column chart visualization?

Hi @anchal5335,

 

In all the visuals the last option on the fields is the Tooltips you can add as much fields as you need to show when you over over the values.

 

tooltips.png

 

The visual above does a sum of value and I added the Text in the tooltip and also % weigth that is a measure I created with the % of the specific value divided by total of all catagories.

 

Regards,

MFelix

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





anchal5335 Helper I
Helper I

Re: How to show detailed Labels (% and count both) for clustered column chart visualization?

Hi MFelix,

 

Thanks for your reply.

But the problem is that I want to show the count and % both as "data label" values for all the bars of histogram, so that at one shot everything is visible (and not by hovering over each bar of histogram individually). Basically what I have seen is that in histograms it shows data labels either as a count or % but how to show both?

Is there any value to do that?

Seward12533 Solution Sage
Solution Sage

Re: How to show detailed Labels (% and count both) for clustered column chart visualization?

@anchal5335Power BI does not handle alternate or customer data labels very well but here is a hack that might work for you.

 

Make your chart a Line and Column Mixed chart put the Count on the Columns and PCT on the Line. 

In the formatting panel

  1. Turn on Data Lables
  2. Under Y Axis be sure Show Secondary is turned on and make the text color the same as your background if you want to hide it
  3. Under Shapes set the Sroke Width to 0 and show markers off (this turns off the line and you only see the labels

You get what you asked for but I don't really like the way its laid out - inconsitent placment sometime % is below the Value and other time above. You may need to play with the secondary axis scaling ( i.e. to push the values for PCT towards the botom of the bars set the Maximum to 1000%)

 

Here is an example

capture20180719014216875.png

anchal5335 Helper I
Helper I

Re: How to show detailed Labels (% and count both) for clustered column chart visualization?

Hi @Seward12533

 

Thanks for your help! This was indeed helful. Can you please explain how to do this?

" You may need to play with the secondary axis scaling ( i.e. to push the values for PCT towards the botom of the bars set the Maximum to 1000%)"

I could now display both count and % values, just not happy with the placing of line values. If any bar of the histogram is tiny then its placing is wierd. So it was be really helpful if you could also guide on that!

 

Also, one more thing- at times pie-chart/donut chart do not show all the data labels, how to work out that so that it shows all the data labels (like some don't show up and we can only see the name and count by hovering over it)?

 

I have been struggling on these for my presentation since past few days, so it would be really helpful if you could guide on that.

 

Thanks,

Anchal

Seward12533 Solution Sage
Solution Sage

Re: How to show detailed Labels (% and count both) for clustered column chart visualization?

For the pie chart you need to make it bigger or try another visual.  If you don't mind ads or can pay for the pro version the Drill Down Donut chart is very slick.  I will also do 100% Row or Columns charts instead of PIE charts. 

 

For the labels if you make the 2nd Y Axis MAX 1000% it will force all the labels to be at the bottom as I demonstrated.

 

capture20180719153930719.png

View solution in original post

anchal5335 Helper I
Helper I

Re: How to show detailed Labels (% and count both) for clustered column chart visualization?

Thank you, this was of great help! Appreciated!

gustavoleo Helper II
Helper II

Re: How to show detailed Labels (% and count both) for clustered column chart visualization?

Thanks for sharing 

 

I couldn't reproduce that 

 

Its possible to share a .pbix example?

Seward12533 Solution Sage
Solution Sage

Re: How to show detailed Labels (% and count both) for clustered column chart visualization?

Helpful resources

Announcements
June 2020 Community Challenge: Can You Solve These?

June 2020 Community Challenge: Can You Solve These?

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

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors