Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
im trying to make a line and clustered chart
that shows Date to average lead time.
Solved! Go to Solution.
Hi @tomb0,
Format function will convert the target value to text with specific text formats.
AFAIk, text value can't be aggregated with common math modes(e.g. sum, average, max, min...), so power bi will forced use 'count' mode to summary these type of values if you use them on the chart value field which only allows the aggregated values.
BTW, current power bi data model tables do not support duration type and you can't do aggregate on the date or time values, I'd like to suggest you convert them to 'total second' values then you can simply do aggregate on them.
Aggregating Duration/Time - Microsoft Power BI Community
Regards,
Xiaoxin Sheng
Hi @tomb0,
Format function will convert the target value to text with specific text formats.
AFAIk, text value can't be aggregated with common math modes(e.g. sum, average, max, min...), so power bi will forced use 'count' mode to summary these type of values if you use them on the chart value field which only allows the aggregated values.
BTW, current power bi data model tables do not support duration type and you can't do aggregate on the date or time values, I'd like to suggest you convert them to 'total second' values then you can simply do aggregate on them.
Aggregating Duration/Time - Microsoft Power BI Community
Regards,
Xiaoxin Sheng