Is there a way in Clustered column chart - show pe...

Anonymous · ‎05-26-2020

Hello Expert,

I'd like to ask if there's a way to show both the percentage and the values in a clustered column chart? Or any chart that would show both?

Please advise.

Thanks

Anonymous · ‎05-27-2020

Hi v-xuding-msft ,

Thank you for your effort. But I am wondering why I don't have the line and clustered column chart in the marketplace. Maybe as a prolicense we need to purchase as it's not part in our package? I like this line and clustered column chart but not sure where to get.

Then I got the percent showing but only in the tooltip if I use my current visual. But my concern now is it defaults to two decimal places ( in show values as percent ). Is there a way we could take out the decimal points?

Thanks

v-xuding-msft · ‎05-27-2020

Hi @Anonymous ,

It is a default visual. We can use it without pro license. If you can't find it, please share a screenshot.

Reference:

Create and use combo charts in Power BI

For the format of percentage, you could select the measure firstly and then change the number of decimal places in Meaure tools. Please see the .gif for more details.

You also can change it in properties.
Reference: Use custom format strings in Power BI Desktop

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎05-28-2020

Hi @v-xuding-msft Xue Ding,

I really appreciate your help and effort and thank you. But with the view it won't still give me the right view on visuals, It should look like this where we could put both the percent and the value in the label as what I had currently it is in the tooltip and with decimal points like this.