Forum Discussion
michaeljc70
10 years agoAdvocate II
Make a column not sum/count
I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations. I am still fairly new to this though and cannot figure this out. I imported a ...
rayaneid
9 years agoRegular Visitor
Hi Michael,
You will need to make sure that the type of the field that you are fetching the data is a whole number and not a Text.
Go to your query editor and when the results are displayed, just right click on the column that you need then go to Change Type - > Whole Number. Remove the field then add it again to your chart and this shall solve your problem