slicer and line graph: aggregated instead of actual values

[agathe_oui]

Hi, I'm new to using PBI and already lost...

I'm trying to create a line graph taking in y price values and in x time values (datetime).
I added a slice (of type between) that allows to select only the desired period.

Problem... impossible to retrieve the real price values, I only have the choice between sum/count/avg/...

The price column is well specified as format "whole number" and as summarize property "don't summarize".

For the slicer, I had to check the "Date Hierarchy" box because I want to have the "Between" type for the slicer.

Can someone please help me, I'm running out of ideas...

[v-kelly-msft]

Hi @agathe_oui ,

Do you have multiple values in Y under the same value in X?If so,the values will be aggregated to get a final value,could you pls upload your .pbix file or part of your data to onedrive business and share the link with me?I will find a workaround for you.

Do remember to remove the confidential information.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[agathe_oui]

*link not accessible*

The graph in question is on page 3.

As you can see, there is no multiple values of y (price) for a value of x (period_start_time).

Thanks for helping me out, looking forward for your explanations.

[agathe_oui · Accepted solution]

finally manage to do it!
have to choose the actual values for the x axis of the line chart instead of the date hierarchy