Dragging a field with values does not create the bars

[Anonymous]

Hi all,

i just dragged a field that has numerical values associated to it (i can see them under filter) but PowerBI won't get me a graph.

Sorry for the newbie question, im a Tableau user 🙂

[v-jiascu-msft]

Hi @Anonymous,

The numbers will show up as numbers in the filters. But they can be in TEXT mode. Please check it out as the snapshot shows and change it to the numerical type. You will get a graph.

Best Regards,

Dale

[Anonymous]

That sounded pretty darn easy but 🙂

Would the csv file help you?

[v-jiascu-msft]

Hi @Anonymous,

Yes, please upload the csv file if you can. Mask the private data first. 

Did you try to change the type in the Query Editor? If they are decimal numbers, you can change them into decimal.

Best Regards,

Dale

[Anonymous]

Here's a link to download the files: https://www.dropbox.com/s/7whv33iv4ze0iuo/20180423_08_36_RPBW_PJP_CUR_BASTION_A13_DETACH_19_LinkedPr...

It's actually the SUM of the numbers of entry.

I'm a Tableau user and Tableau picks it up automatically with the Number of Records Measures

Thank you so much for your help

[v-jiascu-msft]

Hi @Anonymous,

Which column is it? I tried this column "Eye Elevation" without any problem.

Please pay attention to your privacy.

Best Regards,

Dale

[Anonymous]

Sorry i forgot to mention it.

Revit  Type is the value i'm after. Eachlines reports a string (a type) and im looking to get the SUM of all of them.

It's not really some very private info actually 🙂

[v-jiascu-msft]

Hi @Anonymous,

I'm afraid we can't SUM strings. Maybe it's COUNT what you want.

Measure = COUNT('2018'[RevitType])

Or maybe you can assign a number for each type. Finally you can sum up the numbers.

Best Regards,

Dale

[Anonymous · Accepted solution]

I clicked on New Measure and use Count and picked the Revit Type from the list but... where does this measure show and i assume i have to drag it somewhere right?

Sorry for all that

[v-jiascu-msft]

Hi @Anonymous,

You can drag the measure (or other columns ) to the canvas and release the mouse button. A visual will show up. You can change the visual type in the visualization pane.

Best Regards,

Dale

[Anonymous]

Finally 🙂

Thanks a lot for your patience