Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to add multiple lines in clustered Column chart. Do I need to create multiple measures for each line? Is there any easy solution? Ideally I want a line which shows the Total calls for each year at different point in time.
My Output looks like this
Expected Output: Each Year has a different line.
Thanks in Advance.
Cheers,
Vani
Solved! Go to Solution.
Hi @vani2506
If you want to get the same output as you expected, I think create multi measures is a direcrt solution because one line represent one value in the chart.
Attached my sample file that you can refer: add multiple lines in clustered Column chart.pbix
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @vani2506
If you want to get the same output as you expected, I think create multi measures is a direcrt solution because one line represent one value in the chart.
Attached my sample file that you can refer: add multiple lines in clustered Column chart.pbix
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@vani2506 , Multiple lines using legend are not yet supported on the Clustered line chart yet.
Mutiple meausres seem like an option. Of check for some custom visual
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
Please see if this is what you want?
you need to create a calnder table and create relationship between them.
ytd = TOTALYTD(sum('Table'[value]),'datetime'[Date])
Proud to be a Super User!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |