Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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?
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.
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.
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.
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'.
@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.
I was elaborating on your answer for benefit of OP : )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |