Horizontal funnel chart visualization shows dates with T08:00:00.002 at the end

[qazwsxedc]

I use date as series in Horizontal funnel chart. However in the visualization each date e.g. 2019-12-31,2020-12-31......has T08:00:00.002 at the end (looks like 2020-12-31T08:00:00.002). How can I show the dates properly? I added  a calculated column to format the date and it looks ok in this way but I can not use the time intelligence function like sameperiodlastyear to compare YoY % change. Can anyobe helps me? Thanks!

[AllisonKennedy]

I don't know if I fully understand your problem, but do you have a DimDate table? https://allisonkennedycv.blogspot.com/2020/04/dimdate-what-why-and-how.html

A DimDate table is necessary for time intelligence functions to work properly and can give you the opportunity to have the actual date, but also many other columns to format it how you need.

[qazwsxedc]

Thank you for your reply! I do have a DimDate table. The problem is that in the visualization of Horizontal Funnel date looks like 2019-12-31 T08:00:00.002. I added a calculated column Date1=format(EOPBook[date], "yyyy-mm-dd" ) to make it looks like 2019-12-31, it works. However, the 2nd measure of Horizontal Funnel,which is YoY % Change, couldn't show. I guess this is because the format of Date1 is text so time intelligence function couldn't work. After I change the data type from text to date, T08:00:00.002 show up again!

[v-xuding-msft]

Hi @qazwsxedc ,

Do you use the custom visual of Horizontal Funnel by MAQ Software? As I know, it is always showing the original values rather than the formatted ones. Maybe the publisher can help.

Hi @MAQSupport ,

Can you please give some advice for this?

[qazwsxedc]

Yes. It's by MAQ Software. I think this is a bug. Thank you!

[v-xuding-msft]

Hi @qazwsxedc ,

Yeah, maybe it is a bug. You also could contact them at support@maqsoftware.com to receive response.

Hope this can help you.