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.
I am attempting to make a simple scatterplot. I have a column called Months with twelve entries, one for each month. I have a second column for my values associated with each month, which also has twelve entries. When I go to add the values to the plot, Power BI automatically does a count of the values instead of plotting the actual value for each month. I cannot figure out how to prevent this from happening. My data type for the values is whole number, so it is not because the values are strings.
Any help would be greatly appreciated.
Solved! Go to Solution.
Hi @Anonymous
set don't summarize (click on arrow near value field name)
do not hesitate to give a kudo to useful posts and mark solutions as solution
Same issue but with a line graph. I cannot for the life figure this out. My data type is decimal number and there's no option on the click down menu for don't summarize and on the table page the summarization is set to don't summarize. And show value as it is checked no calculation instead of percent of grand total.
Hi @Anonymous
Hi @Anonymous
set don't summarize (click on arrow near value field name)
do not hesitate to give a kudo to useful posts and mark solutions as solution
Iam trying to create a matrix table with multiple columns to display a dashboard. But, when I bring in the decimal value columns from query editor to visualization it does not show actual value. Unless, I set the columns to text field it does not show me the desired values.
Text format is not acceptable for my case as I need to do mathematical functions on these columns to derive operational cost and total cost.
Please suggest.
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |