PowerBI Aggregating IDs

Question

I am using direct query to connect with a local database through PowerBI. However when I import, the IDs are being aggregated automatically when they should not. An example is the MonthID and Year as in the image attached. I also read on this issue, but I do not have the "not summarize" option. I am using PowerBI Desktop. Any solution for this please?

Also I am using PowerBI desktop as I cannot write DAX queries in powerbi.com. Although I will then publish the DAX powerbi desktop report on powerbi.com so as I can share it.

Adding on my question (after Leonard's reply). So I have tried to push a unit capacity value in a barchart. However, it still did not give me the option to 'Do not summarize' as shown in the screenshot below.

Answer 1

The "Don't summarize" option appears when you use the field in a visual. You can ignore the Σ symbol in the field list...all it really means is that the field is numeric (i.e. aggregatable); it doesn't mean that it has to be aggregated.

Try, for example, adding a table visual and adding Year. It may sum them to start with, but you should then be able to click on the down arrow and change to "Don't summarize"

If you add the field to the axis or legend of a visual, then it won't summarize anyway. The "Don't summarize" option only comes into play when it's ambiguous how you might want the field to be treated (such as in a table).