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
fcoalcantarajr
Frequent Visitor

PowerBI CycleTimeDays average and Azure DevOps Cycle Time widget does not return me the same number

Hi y'all. I have been trying to build a panel using PowerBi that includes the CycleTimeDays average for a project. I've followed this tutorial step-by-step: Lead time and Cycle time sample Power BI report - Azure DevOps | Microsoft Learn 

 

But it still diverged from the number shown the Cycle Time widget, which is this one:

fcoalcantarajr_0-1690211419569.png

The value I get by following the tutorial is this one:

fcoalcantarajr_1-1690211458848.png

Can someone help me?

Here's the PBIX file, if it helps: Sample panel.pbix - Google Drive

 

1 ACCEPTED SOLUTION

HI @fcoalcantarajr,

I mean if the line chart and card visual get the same result, it means the expression should worked and equally to the default aggregation effect. The difference results may due to the underlying data source records changes.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

Hi @fcoalcantarajr,

Where did the first result geted? I check your sample file and find the both two card get the same result.(one of aggregated on table fields, the other is measure formula)

If you mean the sample file result, you may need to check the report data source if they not static. The expression result is based on row context, and it may not get the same result if the underlying data records changes.
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @v-shex-msft 

I didn't quite get your message, sorry. =(

But yes, the data is not static, it keeps changing. The source is a Feed OData connection with Azure Boards.

HI @fcoalcantarajr,

I mean if the line chart and card visual get the same result, it means the expression should worked and equally to the default aggregation effect. The difference results may due to the underlying data source records changes.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi, the line chart and card visual sometimes get the same result, but not always. Sometimes it returns wildly different results.

For example, these values are for the same organization. Filters were setup correctly.

fcoalcantarajr_0-1697466609498.png

fcoalcantarajr_1-1697466645631.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors