Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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:
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 39 | |
| 37 | |
| 29 | |
| 24 |
| User | Count |
|---|---|
| 120 | |
| 95 | |
| 70 | |
| 69 | |
| 65 |