Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Charts work on aggregating different values based on your X-axis column name, Try using a table visual.
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".
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
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |