Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Replicate a chart from excel

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

ivoferrari_0-1646743279176.png

 

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?

3 REPLIES 3
Tahreem24
Super User
Super User

@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])

 

Capture.JPG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Anonymous
Not applicable

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?

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.