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 column chart, Columns data is coming form another table.

Please help.

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

4 Replies

  • 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