Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey peeps.
I have pretty much worked with tables and matrixes. This is my first time using a line chart. I have various test readings that I want to show on a line chart but in the Values field, I can't seem to be able to do it. I just want to plot the readings as they are, not summing nor counting. I have played around with the column data type. I tried changing them to "General" "Decimal" but didn't solve my problem. I also set to "Don't Summarize" under Summarize under the column tools.
I saw some other posts with the same issue as mine but they don't seem to be resolved either. What could be the issue here? Is it the way my columns are built? I'm very confused and fraustuated as I can't do a simple line graph. 😕
And similarly, is there any way I could put two column values into a scatter chart?
As I put another column value, it goes under the size field and I can't show normal test readings just like how I want to show in Y axix field.
Thanks everyone in advance.
Solved! Go to Solution.
It depends on the visual that you use. A table visual? no problem.
Line chart has to make a line so there has to be an aggregation involved.
--
What are you expecting to see if using a line chart with 2 or more values for the same x-axis value?
If there is a separate categorisation that can go in the legend, that would create another line but it would still use an aggregation.
That's my understanding.
It depends on the visual that you use. A table visual? no problem.
Line chart has to make a line so there has to be an aggregation involved.
--
What are you expecting to see if using a line chart with 2 or more values for the same x-axis value?
If there is a separate categorisation that can go in the legend, that would create another line but it would still use an aggregation.
That's my understanding.
Hi @HotChilli Thanks for the kind reply. After studying the visualization types in PowerBI, I understood more now.
Cheers!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
37 | |
31 | |
26 |
User | Count |
---|---|
94 | |
50 | |
43 | |
40 | |
35 |