Hi,
I have a barchart and I like the numbers to be shown as 57% (120), where 57% is some calculation (not stacked!) and 120 is the number of observations.
Is this possible?
Solved! Go to Solution.
Not aware of a direct method but a possible workaround may be to use a Measure as a tooltip:
Measure=[M1] & " (" & [M2] & ")"
where [M1]=percentage measure and [M2]=count measure
Hope this helps!
you can do it in the Pie chart from the label style
choose Data value, Percentage of total
couldn't find it in the bar chart
It would be great if that feature is added to bar chart too!
Hi,
I have been trying do the same thing - has there been an update on this?
"Looking to create a visual report in Power BI to compare the number of times people have picked a category. Due to the number of categories to compare(7) I have tried using the Bar Chart. The only issue is I want to display the data with the count of picks and the percentages of that pick as part as a total.
Is there a way I could do this in Bar chart?"
I could do this in Pie chart but it seems like the bar chart could only allow you to do one or the other
Not aware of a direct method but a possible workaround may be to use a Measure as a tooltip:
Measure=[M1] & " (" & [M2] & ")"
where [M1]=percentage measure and [M2]=count measure
Hope this helps!
As a tooltip yes but I don't think in the actual chart itself.
Proud to be a Super User!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
User | Count |
---|---|
437 | |
151 | |
109 | |
51 | |
50 |
User | Count |
---|---|
458 | |
141 | |
131 | |
80 | |
71 |