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,

 

>>For each grouping in the chart (can  be seen by the green/black/red bars) on the second Y-axis I want to plot a discrete value so effectivly only one plot per grouping.  This chart joins the discrete points into a line.

Did you want to switch the same color bar to one group, right?

 

If this is a case, you can try to exchange the Shared axis and Column series fields of "line and clustered column chart".

 

Regards,

Xiaoxin Sheng

dax_bee's avatar
dax_bee
Frequent Visitor
9 years ago

Hi Xiaoxin

 

Ideally I am looking for a chart which will generate the following.  The line being replaced by discrete points (in this example triangles)

 

 

 

  • 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