Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi ,
I have 2 columns
1.dat and time
2.program number
i am using line chart, with values below:
x-axis : date&time
y-axis:program number.
When idraw line chart on Y-axis it is shwoing sum of all program number but i want to display only program number without any aggrigation.
example data set:
Date programenumber
29-3-19 09:30 101
28-3-19 09:30 101
28-3-19 09:30 102
28-3-19 09:30 103
29-3-19 09:30 102
29-3-19 09:30 104
27-3-19 09:30 105
27-3-19 09:30 101
please help me here
Solved! Go to Solution.
@Anonymous ,
You may take advantage of the Legend field.
https://community.powerbi.com/t5/Desktop/graph-trouble-summing/m-p/564094#M266151
@Anonymous ,
You may take advantage of the Legend field.
https://community.powerbi.com/t5/Desktop/graph-trouble-summing/m-p/564094#M266151
User | Count |
---|---|
99 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |