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,

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

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