Line and Clustered Column Chart

[dax_bee]

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 line.

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.

I aprreciate that this chart is designed to work this way, does anyone know of any other available visuals which would allow me to do what I want?

[v-shex-msft]

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]

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)

[v-shex-msft]

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]

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.

[v-shex-msft]

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]

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.

[Greg_Deckler]

Not aware of one. You will probably have to do some kind of R visual to get what you want.