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 beco...
Need Help
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