Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!