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

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 New Contributor
New Contributor

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

8 REPLIES 8
Super User
Super User

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



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

Proud to be a Datanaut!




anchal5335 Regular Visitor
Regular Visitor

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 New Contributor
New Contributor

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 Regular Visitor
Regular Visitor

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 New Contributor
New Contributor

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

anchal5335 Regular Visitor
Regular Visitor

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

Thank you, this was of great help! Appreciated!

gustavoleo Regular Visitor
Regular Visitor

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 New Contributor
New Contributor

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