Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |