stacked and column chart

[pankajdeol]

Hello Champs, I have a table containing One column, "ID" and 2nd column, "Order type". Now I want to display 2 lines displaying count of ID over the time based on the order type in a combined stack column chart, Columns data is coming form another table.

Please help.

[v-huizhn-msft]

Hi @pankajdeol,

I try to reproduce your scenario using the following sample table, but I can't imagine what it looks. Could you please share your resource table? 

>>count of ID over the time based on the order type in a combined stack column chart, Columns data is coming form another table.

Which date will be shown in line and please post your data in another table.

Best Regards,

Angelia

[pankajdeol]

Hi @v-huizhn-msft, Thanks for your reply. I am attaching a sample data screenshot . Please see if this can help to understand the data.

[v-huizhn-msft · Accepted solution]

Hi @pankajdeol,

You can create two measures using the formulas below.

Order Type1=CALCULATE(Counta(Table[OrderType]),FILTER(Table,Table[OrderType]="Order Type1"))

Order Type2=CALCULATE(Counta(Table[OrderType]),FILTER(Table,Table[OrderType]="Order Type2"))

Then add two measure above as Line values.

Best Regards,
Angelia

[pankajdeol]

Thanks Angelia. this works great.