Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |