Forum Discussion
Funnel Data Format
Hi, Anonymous
It is unsupport to put a formatted text in 'Values' of a visual. Only number data type can be put in the 'Values'. I'd like to suggest you calculate the total hours or total minutes as a workaround.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a measure as below.
Avg =
var x =
AVERAGEX(
'Table',
HOUR([Date])*3600+[TotalSecond]
)
var h = INT(x/3600)
var m = INT(MOD(x,3600)/60)
return
h&":"&m
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Allan,
Thank you for your help.
Unfortunately, it doesn't work either.
I built the funnel on your pbix file, but I cannot use the measure "Avg" in the "Values" part.
So I built a calculated column to put instead, but it just displayed the number "1" for each date.
What I'd like to obtain is the funnel but with the HH:mm value on each line.
Do you have something else to try ?
Best regards,
Martin.
Hi, Anonymous
It is unsupport to put a formatted text in 'Values' of a visual. Only number data type can be put in the 'Values'. I'd like to suggest you calculate the total hours or total minutes as a workaround.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you for your answers, I'll try it and see if this is worth it.
Best regards,
Martin.