Forum Discussion

dax_bee's avatar
dax_bee
Frequent Visitor
9 years ago

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...
Need Help
dax_bee's avatar
dax_bee
Frequent Visitor
9 years ago

Hi Xiaoxin.

 

There may be a little confusion here.  Ideally I am looking for a chart which displays both Chart & discrete points (not line).  If as per your comments you feel you have an example of this please post an image.

 

Thanks.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

  • dax_bee's avatar
    dax_bee
    Frequent Visitor
    9 years ago

    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.