Two Identical Pivot Charts behaving diff (Hourly Grouping)

I am learning Pivot Tables and Charts, I built out this dashboard with Pivot Tables. One of them simple has OrderDate in the Rows field and that data consists of the date and a time stamp.

I used group and chose hours and it automatically named them by the hour like "11 AM, 12 AM, 1 PM" etc.

I then remade the exact table with the exact data but this time I "added to data model".

When I group this time it adds an extra item in the rows (OrderDate and OrderDate(Hour) - and the fields are listed as 0, 1, 2, 3, 4 instead of 11 AM 12 AM etc.

I cannot figure out why or how to get it to display the other way. It is super frustrating. I know I can manually type those names in but I want to learn why it is behaving this way?

Related it seems that Excel added "OrderDate (Month)" and "OrderDate (Hour)" to the fields list for some reason. Also the "Starting" and "Ending" dates are greyed out. Definitely something different here...and the only thing I did differently was adding to data table. I had to do this because Distinct Count only shows up when I use a data table.

My assumption is it is something to do with the data model using OLAP (not sure what that means). That leads my to my initial reason for using the data model, there was no DISTINCT COUNT option for fields in the non data model method. So I am not sure what workaround to use for that?

The only other solution is a helper column but I have 800k rows, so this is not very viable. Takes 30-60 mins to run, and this report needs to stay updated daily

Edit: I then decided to just rename them using data model because I need to finish this by tomorrow and when using the data model, the slicers don't use the name you manually type in so now the names are all wrong AND won't sort. So frustrated. (see image)

Yeah I got it all working now. It was a little wonky but it is working! Few kinks but I think I am good now =D

Only thing I am wondering now is before sharing a dashboard can I delete my actual dataset once I am finished? It's stored in the data model right now correct? As long as no one hits REFRESH it will all work?

That way I can have a "working" version and an "exported" version for sharing. Every week I will update the working version and then replace the exported version with it after I update - is this right?

Because this thing is 250MB as it is and that's bad for sharing.


And the one thing I COULD NOT figure out is how to rename the slicers items using the data model version. Excel always seems to give them default formatting and changing them does nothing. In the old normal Pivot Table without data model if I renamed those groups the slicer automatically updated with those names. I have OrderDate(Month) slicers and I renamed the groups to long name months but it still shows them automatically as short name months. Annoying!