Power BI - "Do not summarize" missing - Not showing actual data

[marketwasher]

Please help! I am looking to make a chart to show the actual data by month. But "Do not summarize" is not available. Please advise

I already converted all data to numbers.

Here is the chart I am looking for.

[v-frfei-msft]

Hi @marketwasher ,

Kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[marketwasher]

Here you go. 

https://1drv.ms/u/s!At63WG1Ca9PbmSuyMB5DvBNaHhJ-?e=6raM66

Thanks for your help.

[v-frfei-msft · Accepted solution]

Hi @marketwasher ,

Change the values from count to sum to work on it.

For more details, please check the pbix as attached.

[az38]

Hi @marketwasher 

you are using higher level of date hierarchy

remove Quarter and Day from axis field then press on "Expand all down" button in visual, which looks like

do not hesitate to give a kudo to useful posts and mark solutions as solution

[marketwasher]

Thank you for the swift response. That fixes the date but the "count" is still showing

Here is what I have so far.