Forum Discussion
Line and Clustered Column Chart
Hi. I am currently using the Line and Cluster Column chart within one of my reports (see below). Ideally I want the Line element of this chart to show discrete values only and not a continous lin...
Hi dax_bee,
Sure, below is my sample file:
Source table:
Table = ADDCOLUMNS(CALENDAR(DATE(2016,1,1),DATE(2016,12,31)),"Month",FORMAT([Date],"mmmm"),"Day",FORMAT([Date],"dddd"),"Amount",RANDBETWEEN(0,100))
Notice: I add the filter to filter first three months, the line value is the average of amount.
Regards,
Xiaoxin Sheng
Hi Xiaoxin.
Appreciate the update, but as per my previous comments the requirement is a bar chart + discrete points on a seperate Y-axis. Your solution is currently acheivable with the out of the box "Bar & Line chart".
If you re-read the thread this may provide you with greater clarity as to the issue I have.
Thanks.