Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Why are we marking "Closest Answers to the solution but not the solution to the question" as a solution. What purpose does it solve?
The correct solution should be of @Greg_Deckler "As a tooltip yes but I don't think in the actual chart itself."
Secondly, coming to the solution of the "tooltip measure" by concatenating, that's not even required. Just drag and drop the "values" and "percent of total". It will show as a tooltip as such.
As a tooltip yes but I don't think in the actual chart itself.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |