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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.