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.
Hello Expert,
How to get Sum number in charts like highlighed in below mentioned screen. Help with the step
Shree
Solved! Go to Solution.
This will result in you 37,4 value appearing in the chart as a new column. You need to use the country column from the country table as it is the only one that has the Total column value!
/ J
Change the postition option on your graph to "inside end" in the data labels options.
Thanks..
This is data label. How 37.4 value we can be added in chart
Shree
Sorry i missunderstood. 37.4 can be added but its quite complicated.
What is the legend dimension that you are using?
Is everything in one table or do you have dimension tables?
1)Dimension is country
2)everything is in one table
This would require you to change your datamodel, but what you would need is something like this:
By creating double crossfilter relationships between these three tables you can get a "Total" value in your country dimension that is mapped to all of your countries. This should give you the result you are looking for!
/ J
will it populate like 37.4 (KPI) value in chart and which column to be added like in dim and fact in your case
This will result in you 37,4 value appearing in the chart as a new column. You need to use the country column from the country table as it is the only one that has the Total column value!
/ J
Hi,
it is showing as column in chart ..i want this kpi to be populated along with chart
Shree
Along with bar chat that number should display
same
It's not possible. The closest you can get is adding an average if you're working in percent:
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |