Displaying Column numeric value with Date on X-Axis

[mali130]

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

[mali130]

Hi Jorge, each date has one for one particular column

[JorgePinho]

If you right click on the Value column do you have the "Don't summarize" option?

[mali130]

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. 

[JorgePinho]

Can you provide some print screens of your table and visual?

[mali130]

[JorgePinho]

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"

[mali130]

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;

[JorgePinho]

It's probably because of your data model. Try using max and check if you get the desired result.

[mali130]

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 ?

[JorgePinho]

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.

[mali130]

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. 

[JorgePinho · Accepted 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.

[JorgePinho]

In your data model each date has only one value? Or there are multiple rows with values for the same date?