Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Replicate a chart from excel

Hello! I'm trying to replicate a chart from excel which has this:

 

Where "Tickets" is the amount of items in the chart. When I try to see how its made I see this formula:

"='Cycle Time'!$F$2:$F$115", how can I replicate this chart in power bi? By a count measure maybe?

Need Help

3 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    4 years ago

    Anonymous, You can select the column and select the aggregation type "COUNT" or "SUM" as per your need. Else you can also create a measure seperately for each field.

    COUNT MEASURE = COUNT(TableName[Ticket Column])

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I dont think thats my issue, let me make myself clear, I want down there a value that updates depending on the filters I have and returns the number of tickets that are being filtered.

      For example from 1 to 10 or 1 to 100, do I make myself clear?

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        Hi, Anonymous 

        I'm not familiar with excel formulas.

        Can you share your sample data and expected results directly? So that I can understand your problem more directly and write the corresponding formulas.

         

        Best Regards,
        Community Support Team _ Eason