Dont want count | How can I stop Power BI from presenting count of values?

[anioko1]

I am new to Power BI and I am using Power BI desktop to visualize some data but it keeps showing count of values even when under the Default Summarization I choose “Do not summarize”. Please what other ways can I get the data without it calculating the count?

[Rodneysing]

My data does not need to be counted. It’s coming from an SQL database, where all the calculations have been performed. I just need Power BI to give a high level dashboard and graph of the data. How do I stop Power BI from presenting a count of values?

[Baskar]

am not clear on your question ...

but based on my understanding,

1. U r trying to use the measure in value field.

2. Check your measure datatype.

If not let me know with little bit more explain.

[sdjensen]

Could you perhaps elaborate a little more? Perhaps show some samples of your data?

What is the datatype of the value you put into your visual? I think if the value is a text type then Power BI will count if you put it into the value of your visual.

[sdjensen]

I have created a small dataset containing one table with 2 columns. The 2 columns is identical but one is of the type text and the other of the type whole number.

 

As you can see - when I add the one formatted as text it count but when I add the one formatted as a number is sums the values.

[curtisp]

It doesn't look you have put the 'ValueText' as the x-axis field. The bar chart is interpreting this as two columns of data to chart one named 'ValueText' and the other 'ValueNumber'.

[sdjensen]

@curtisp - I was trying to illustrate the difference of adding a value formatted as a number versus a value formatted as a text to a visual. I know what it's doing.

[curtisp]

I was elaborating on your answer for benefit of OP : )