Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What is the expression you are using currently? Would you be able to share a screenshot to see the issue?
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
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.
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?
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