Forum Discussion
indexed chart
Hello
I do see similar posts to what I am looking for, but it seems like this would be simple DAX indexed chart.
(data date about 2-3 years)
I have a dataset like :
Date Type Price
22.05.2020 A 110
23.05.2020 A 140
24.05.2020 A 180
25.05.2020 A 210
26.05.2020 A 200
27.05.2020 A 140
28.05.2020 A 135
29.05.2020 A 165
30.05.2020 A 175
31.05.2020 A 174
22.05.2020 B 80
23.05.2020 B 120
24.05.2020 B 145
25.05.2020 B 231
26.05.2020 B 245
27.05.2020 B 221
28.05.2020 B 115
29.05.2020 B 245
30.05.2020 B 330
31.05.2020 B 187
22.05.2020 C 17
23.05.2020 C 71
24.05.2020 C 149
25.05.2020 C 121
26.05.2020 C 15
27.05.2020 C 81
28.05.2020 C 91
29.05.2020 C 99
30.05.2020 C 99
31.05.2020 C 209
My goal is making a indexed chart which is start at 100. My final chart would be:
1 Reply
dethnass ,
if you are looking for the table below, the chart that is not possible. You can have a line visual with legend as Type.
you can have matrix visual separately.
But as the example data and visual do not march can not suggest what to do
refer :
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Group visual together
https://docs.microsoft.com/en-us/power-bi/desktop-grouping-visuals
