getting avearge as zero with KPI visualisation

[NKadam]

Hi Team,

I am creating KPI visualtion for average of total open hours of ticket for this I am selcting average total open hours as indicator and closed date as trend axis but I am getting average as zero, what I need to do to get average displayed with closed date ?

[v-yuezhe-msft]

@NKadam,

Do you get expected result when you put average total open hours and closed date in other visuals? Could you please share dummy data of your table here?

Regards,
Lydia

[NKadam]

@v-yuezhe-msft Thanks for replying .. Yes I do get correct result when I use  other visuals. following is the dummy data

Closed Time	Total Open Hours
3/26/2018 13:10	41
3/27/2018 12:31	41
3/28/2018 13:13	0
3/28/2018 13:34	58
3/28/2018 14:36	2
3/28/2018 16:15	2
3/29/2018 0:00	60
3/29/2018 0:00	89
3/29/2018 0:00	71
3/29/2018 9:06	70

[v-yuezhe-msft]

@NKadam,

How do you create average total open hours based on the above sample data?

Regards,
Lydia

[NKadam]

@v-yuezhe-mst
Hi Lydia,
I am selecting total open hours as indicator and then right click selecting average

Thanks
Nivedita

[NKadam]

@v-yuezhe-msft Also I tried creating measure of average total open hours .. getting same result

[v-yuezhe-msft]

@NKadam,

KPI visual works as expected in my scenario. Do you use Power BI Desktop May release and do  you have any filters for the KPI visual?


Regards,
Lydia

[NKadam]

@v-yuezhe-msft

Thank you Lydia.. Upgraded to May version and now I can see  the graph, but still average is not correct

[v-yuezhe-msft]

@NKadam,

I am unable to reproduce your issue, would you mind sharing me your PBIX file via Private Message? Does my screenshot return your expected result?

Regards,
Lydia