Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a column in my data called "Number of days to respond". I'd like to show the average of this in a card visual. I tried going to the Data Field, but it only allows me to show the first or last values, or a (distinct) count. Can anyone help please? I'm a beginner.
Thanks
Solved! Go to Solution.
Hi @Anonymous
Please click the column, then check if the type of the colmn is whole number
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
In the Query Editor, change the data type to Whole number and write this measure:
Avg = average(Data[Number of days to respond])
Hope this helps.
Hi,
In the Query Editor, change the data type to Whole number and write this measure:
Avg = average(Data[Number of days to respond])
Hope this helps.
Hi @Anonymous
Please click the column, then check if the type of the colmn is whole number
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi @Anonymous
this happens when the column is not of number type. Check your data type of [Number of days to respond] first.
Numbers should have the sigma sign:
Hi, thanks for replying. It doesn't have a sigma sign.
Hi @Anonymous
That is the issue. You have at least one nonnumeric in that column. You have to replace/delete it in your data source or Power Query processing,
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |