Calculated Measure on Chart

[Anonymous]

Hello,

I have a measur like bellow. But i didn't use this measure on chart. How can i solve this problem?

Measure = VAR TotalSeconds =
    SUMX (
        'Mesai_Talep_Formu',
        HOUR ( 'Mesai_Talep_Formu'[Süre_Mesai] ) * 3600
            + MINUTE ( 'Mesai_Talep_Formu'[Süre_Mesai] ) * 60
    )
VAR Days =
    TRUNC ( TotalSeconds / 3600 / 24 )
VAR Hors =
    TRUNC ( ( TotalSeconds - Days * 3600 * 24 ) / 3600 )
VAR Mins =
    TRUNC ( MOD ( TotalSeconds, 3600 ) / 60 )
RETURN
    IF ( DAYS = 0, "", IF ( DAYS > 1, DAYS & "days ", Days & "day" ) )
        & IF ( Hors < 10, "0" & Hors, Hors ) & ":"
        & IF ( Mins < 10, "0" & Mins, Mins )

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Power BI doesn't support to put Time or Text data in Values field on bar chart / column chart. And Power BI doesn't have Duration type in reports. You can remain the TotalSeconds and return it as result in the measure. Or you can also convert TotalSeconds to Minutes / Hours and return the result. Below is an example for TotalMinutes. 

Measure1 =
VAR TotalSeconds =
    SUMX (
        'Mesai_Talep_Formu',
        HOUR ( 'Mesai_Talep_Formu'[Süre_Mesai] ) * 3600
            + MINUTE ( 'Mesai_Talep_Formu'[Süre_Mesai] ) * 60
    )
VAR TotalMinutes =
    DIVIDE ( TotalSeconds, 60 )
RETURN
    TotalMinutes

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[VijayP]

@Anonymous 

I have checked your File , Since the measure producing Pure Text , and Value will not allow the Text Measure you will not be able to use this on any chart with filter context

[Anonymous]

Thank you @VijayP 

Isn't there a solution to this? 

[VijayP]

@Anonymous 

if you can share pbix i can help , but Have you changed that to duration and check whether it is working?

[Anonymous]

@VijayP 

I sent the pbix file with a private message. Thank you.

[VijayP]

@Anonymous 

The Formula Result is a Text as you are using Concatination. 

It will not be allowed on any chart except in Table. 

In any other chart it should be numeric Value!

[Anonymous]

Thank you @VijayP 

So how can we change this measure to numeric? reference topic is here. 
https://community.powerbi.com/t5/Desktop/About-Time-Calculation/m-p/2325715