Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How not to aggregate values in charts

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

 

 

Need Help

3 Replies

  • JaySharma's avatar
    JaySharma
    Frequent Visitor
    3 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        JaySharma
        Frequent Visitor
        3 years ago

        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