Forum Discussion
Counts and percentage
Hi all,
I am finding out if there in PBI not possible to visualize counts and percentage in the same column chart.
I found lastest commnet from November 2020 so I am interesting if there is any change since this time.
Anybody knows?
5 Replies
- AllisonKennedy
Community Champion
JankoG You could try Charticulator for this:
Or you could try the Area chart - not a column I know, but it does give some cool options for plotting on two different scales, which is what you'd need for percentages and values.
https://excelwithallison.blogspot.com/2021/09/visual-review-area-chart.html
Otherwise you could rely on Tooltip to provide the %, but that's not ideal:
https://excelwithallison.blogspot.com/2021/09/tooltips-in-power-bi.html
Hi JankoG
You can visualize counts and percentage in Line and clustered column chart .Then turn on Data label in visual format .
I have attached my pbix file , you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ailsa, thank you for your help. But this is not what I looked for. I knew about this option. My coluege for whom I am creating report asked me if there is possible to show % and count in one column and I told him that it is impossible. But I just asked for his satisfaction. I told him that is impossible to show two values in one column.
- AllisonKennedy
JankoG Does your colleague have a picture of what what they want/have in mind? There are many custom visuals out there which can help acheive many things, just may need to develop it a bit.
