Forum Discussion
Creating a line chart using non summarized values
Hi,
I need to show line chart where x-axis has time and y-axis shows glocuse level. when i put this on chart, y-aixs only gives me option to summerize glocuse level. I dont see "Don't Summerize" option. In Model i have set glocuse level column "Don't Summerize". any help would be greatly appriciated.
| Time | Glocuse Level |
| 02:09:54 | 97 |
| 02:14:54 | 97 |
| 02:19:54 | 99 |
| 02:24:54 | 103 |
| 02:29:54 | 104 |
Looking for something like this that i was able to do easily in excel,
Hi desaitapan1
Any field added to the value or y-axis tile of a line chart will need to be aggregated/summarized one way or another based on another field/x-axis. Looking at the times which are hard to read due to orientaiton, there aren't repeated ones. If you want to make it look like that in Power BI change you y-axis to categorical insead of continuous.
2 Replies
The summarization would only apply if there multiple values for a specific time. Otherwise any of the summarization would be that of a single value.
Hi desaitapan1
Any field added to the value or y-axis tile of a line chart will need to be aggregated/summarized one way or another based on another field/x-axis. Looking at the times which are hard to read due to orientaiton, there aren't repeated ones. If you want to make it look like that in Power BI change you y-axis to categorical insead of continuous.
