How not to aggregate values in charts

[Anonymous]

Hi all,

I am new to Power BI. I made a "line and stacked column chart". When I only have 2 groups of values, the chart looks normal. But when I want to add on the 3rd group of values, the chart becomes weird. I noticed this is because the 3rd value was aggregate by default, but I just would like to show the scrap value. I already change the properties to "Don't summarize". Can anybody help me on this?

Thank you in advance,

Katia

The charts seems normal with only 2 groups of values

I already change to "Don't summarize"

Power BI force me to choose one aggregation

[JaySharma]

Charts work on aggregating different values based on your X-axis column name, Try using a table visual.

[Anonymous]

Thanks for your prompt reply. But tables are not easy to tell the trend (all numbers, but not graphs). I would like to show the correlation between "sales volume", "share of search (%)", and "page view".

[JaySharma]

Seems like there the issue is with the visualization choice. Maybe check this out. 
Also, I don't see "Sales Volume" and "Average Score" in the table snippet you shared, also, I'm not sure which column "Share of search" correspond to,  If you need further help, \ maybe share some dummy data with well-named columns? Please avoid sharing sensitive data, I'd love to assist you further. 

Regards,
Jay Sharma