Trouble Entering a new measure into a value

[Anonymous]

Hi,

I am currently creating a PowerBi dashboard and have already created multiple measures that are working fine on different graphs. I have just made a new measure and PowerBi won't let me drag and drop the measure into the values section of a line chat. 

Any ideas as to why this might be happening?

Cheers,

[AndreFSD]

@AllisonKennedy @Greg_Deckler  Hi there, having the smae issues as the top. Ive cretaed a quick measure, it displays correct on visual table and when i select a graph Funnel it doesnt allow me to drop into the value. Any idea? the text is displayed in Hours "HH:MM" any help would be much appreciated......... 

[AllisonKennedy]

@AndreFSD It sounds like your measure is Text so can't be displayed in a funnel chart that wants a numeric value. 

[AndreFSD]

Hello @AllisonKennedy  thanks for the reply im new to this and trying to get some statics for some of our activities.

So i have a colum that has a the date and on another colum i have the average time that an activity took per each day

ive use thsi formula to display the average 

Average Hours taken =

FORMAT(AVERAGE('Table 1 (Sheet1)'[Hours taken to clear]), "HH:MM")

On a table it displays perfect but how can i get it to display on another chart?

Any help is much appreciated.

Thank you!

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I agree with @Greg_Deckler. It may be caused that the result is not a number. Please drag the measure into a card or a table to check it. And then choose a proper visualization to show it or modify the measure.

If it still doesn't work, please share a few screenshots.  We will understand more clearly.

[AndreFSD]

Hi there, having the smae issues as the top. Ive cretaed a quick measure, it displays correct on visual table and when i select a graph Funnel it doesnt allow me to drop into the value. Any idea? the text is displayed in Hours "HH:MM" any help would be much appreciated......... 

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.

[Greg_Deckler]

Huh, that doesn't sound right, is your measure returning something other than a number?

[AllisonKennedy]

Can you please provide some more information. I can't think of why a measure wouldn't be able to go into a value, but if you can provide details we can try to help you out.