Display numbers and % together in bar chart

[#1]

Hi ,

I have a bar chart that shows the sales numbers across years. I also want to show the sales % alongside the sales numbers. How can I do that?

I have tried using a combo chart but then it does let you show the data values which is something I want. Please help.

[sunny_talwar]

What is the expression you are using currently? Would you be able to share a screenshot to see the issue?

[#3]

Following is my expression:

if( Selection='Self', sum(#TotalSelfLed)/sum(UniqueParticipantCount),
if(  Selection='Rep', sum(#TotalRepLed)/sum(UniqueParticipantCount),
if(  Selection='Phone', sum(#TotalPhone)/sum(UniqueParticipantCount),
if(  Selection='Total', sum(#TotalGuidance)/sum(UniqueParticipantCount),

)))
)

Through this I am displaying the % values but I also want to show the gross numbers on this chart. I tried using the combo chart but it does not let you label the data values which is something we want.

Please suggest.

Thanks

[Anonymous]

Hi Neha,

It can be done if you use 2 measures and choose from the number formatting number and percentage to the measure you want to display as percentage.

[#5]

Hi Chandrashekhar,

Thanks for the suggestion. This works for me but now I am not able to color the bars by measure. I do not want single colored bars. Can I do that?

[jonbmorrison]

Even better - you can make the percents on a second Y axis so they could be a line vs just a number at the bottom of the bars.

You can do color by measure -

Appearance

Colors and Legend

Select Custom

By Expression

and fill in your expression there

or just chose multi-colored if you have more than one set of bars to present