Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi PowerBI Champs,
I am plotting a graph with a numercial value on y-axis and date on x-axis. Whenever i plot the y-axis measure it shows me the count. I just want it to plot the real numeric value and percentage value (for another graph). Can you pelase advise how to do that. Much appreciated.
Regards,
Ali
Solved! Go to Solution.
Since it is only one point it doesn't make a difference if you use average, max, min since it will return the only value.
Count will count the amount of values for each date that is 1.
Hi Jorge, each date has one for one particular column
If you right click on the Value column do you have the "Don't summarize" option?
I do see that and i choose that. But even after doing that when i plot it on y-axis it comes as a count.
Can you provide some print screens of your table and visual?
The summarization that you highlighted is the default summarization, what doesn't guarantee that is the one being used by the visual.
Please click on the arrow that I marked with a red circle and choose "Don't Summarize"
Hi Jorge,
I dont know why i am not able to see the 'dont summarize' option when i click the arrow that you highlighted. Please see below;
It's probably because of your data model. Try using max and check if you get the desired result.
Actually using average also gives me the desired result but was wondering is that a normal behaviour. Should i try changing the data type from Whole Number ?
The Summarization options depend on the visual you're using. In line chart visual, "Do Not Summarize" is not available but in a table visual it is, for example.
I see, so i guess the best way is to maybe use an average value or use the max as it will solve the issue in my case.
Since it is only one point it doesn't make a difference if you use average, max, min since it will return the only value.
Count will count the amount of values for each date that is 1.
In your data model each date has only one value? Or there are multiple rows with values for the same date?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
78 | |
78 | |
58 | |
35 | |
32 |
User | Count |
---|---|
99 | |
59 | |
56 | |
46 | |
40 |