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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi dax_bee,

 

>> The line being replaced by discrete points (in this example triangles)

I think the issue may related to your formula which store on the line value, it not appeared on my side.

 

Regards,

Xiaoxin Sheng

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.