Combining Multiple items from one day into a single total for the month

[Anonymous]

Hello everyone. I am new to Power Bi and DAX, so please forgive me. I can make this all happen in excel, but not in Power Bi...

I am trying to make a Line chart where it shows we have done "X" bids in "X" month in year "X". The chart currently shows "X" bids per day. How do I aggregate them into a single month and still have it broken down per year?Current chart w/ slicers shown.

[Greg_Deckler]

So typically you would put the Date hierarchy in the x-axis and then you get the drill down features available to drill up and down through the hierarchy. Is that what you are asking?

[Anonymous]

That is what I thought, but every time I add Month, Year, QTR, etc. to the axis, the data disappears. I even tried creating a simple table on a new "tab" I can get the count to show up, but when I add in a slicer by Month, again it disappears.

[Anonymous]

What is odd about it, is the page filter shows a count for each month, but when I select Jan, the data is gone.

[Greg_Deckler]

@Anonymous can you share an example PBIX via OneDrive, Box or something? Or sample data? 

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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

@Greg_Deckler, It may be easier to do a Microsoft Teams or Google meeting. Thoughts?

[Anonymous]

@Greg_Deckler Here is the link to one drive, sorry it took a minute to get everything copied over to a sample file.

Sample File 

Let me know if that works...

[Greg_Deckler]

That just links back to this post.

[Anonymous]

That's awkward.... Try this one. 

Sample File and Date Table 

[Anonymous]

Team,

I figured it out. The format of my Table[Column] was date/time. Once I changed it to "Date" only, It worked. Thanks for the responses.

[Greg_Deckler]

Ahhh, good one, yes. I have seen that where the time components are different. Good job figuring that out, that's a bear to figure out sometimes!