Forum Discussion

pankajdeol's avatar
pankajdeol
Frequent Visitor
9 years ago
Solved

stacked and column chart

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 c...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

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's avatar
pankajdeol
Frequent Visitor
9 years ago

Thanks Angelia. this works great.