How to present data individually <HELP>

[Pedroooooo]

Hi All,

I would like to present my figures individually (as shown in table B) but my visualisation in table A shows the total of the year instead of the individual month's figure. Any idea how to prevent it from summing up?

   

 Table A                                     Table B

[v-chuncz-msft]

@Pedroooooo 

DAX Studio can be used to capture queries, you may have a look.

[Greg_Deckler]

If it is a column, use the drop down and choose "Do not summarize"?

[Pedroooooo]

hi @Greg_Deckler ,

It tried many times and it still doesn't work. My data are all in numerical figures so I believe my data has no issue?

[Greg_Deckler]

Going to need sample data to recreate issue. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[CheenuSing]

Hi @Pedroooooo ,

Can you upload sampledata, pbix to Google / OneDrive and share the link here to find a solution.

Cheers

CheenuSing

[Pedroooooo]

Hi CheenuSing,

Thank you for replying so promptly. Sadly I can't as it contains personal information.