How to disable default summarization of data

[Anonymous]

Hi

I have read a bunch of similar questions related to my one, however, I was not able to find a solution to fix my issue.

I have a "whole number" data type column which I have calculated, and I would like to to use this column as the value in a clustered chart. My issue is that Power Bi summarize this column by default and I don't need this I need just as it is in a table. I have disabled summarization for the column in the modeling tab 

, however, my values are on a count by default and I don't have an option to choose there for "Don't Summarize" option. I have tried to change the data type from the "Whole Number" to the "Text" but it also didn't help me. Is I am using the wrong chart or I need to add some formating to my query?

Thanks for the help.

[AnthonyTilley]

Hi im not sure what you are trying to accomplish but i think the issue is that you have the colunm in teh values filed 

a value filed will not allow a non sumerized value as the value is always an aggregated field so will only allow a MAX.MIN,COUNT SUM etc. 

if the filed is moved to the Ledged, or axis filed of the visual tehn it should work fine with teh settings you have 

if there is something i am missing then please let me know and i will try to help.

preferable show a screen shot of your visual and some sample data 

Regards

[Anonymous]

hi @AnthonyTilley ,

I think this is a dummy question but it is important for me to understand where I am wrong.

I will give another example. I have a table with two columns (projects and duration) and I would like to visualize in a chart duration for each project. How to do it? Because as you can see from the screenshots below chart is showing count value for each project which doesn't have any sense for me. So how to avoid counting or any other summarisation in charts? By the way, summarisation is set to the Don't Summarise under "Modeling" tab for the duration column.

Thank you very much for your help.

[AnthonyTilley · Accepted solution]

Hi @Anonymous 

A chart or table will always summerize  when a field is added to the value secion 

in your example you have added duration to the values. because the duration filed is set to "Do not sumerize" it will default to Count in this case you have 1 entry for each project in your table so your chart is showing every project as 1.

in order to show the duration value you need to use SUM as the SUM of say project 1 is 150 so that would make your chart show what your after. 

for best practice you should change from "DO NOT SUMMERISE" to SUM

only Dimentions such as your project colunm should be left as do not summerise.

You have to remember that although your field for duration is already the value you want to show it cannot be input as a value it has to first be summerised. for example lets say instead of having one row with Project 1 duration 150

you had two rows as below 

Project_1	75
Project_1	75

in this case you would want to sum(duration) to get a total of sum(75 + 75) =150 

when there is only one row as in your example then the sum still works sum(150) = 150

i hope that makes sense 

[Anonymous]

Hi @Anonymous 

As far as my knowledge goes, it is to do with the type of chart you are using.

If you were to use the 'Table' visualisation for your data, you will see the 'Don't Summarise' option.

I don't believe Clustered column charts allow you to bypass the summarisation. I would instead look to maybe filters and/or slicers to make the visual show you what you are looking for.

Hope that helps

Daniel