Changing Column to Two Groups

Hi villasenorbritt ,

If this hour in fact table, then don't make any change in this table. Just create a Dimension table with shift timing and make a realtionship with Hour of dim table with your fact table with Hour columns. Advantage of this is, you have more control on slicing and filtering of the data in your report.

To make a dim table, I would suggest that at first prepare it in excel as below:

Why, because this is a kind of fixed table, and should not change so often.

Then copy it. Ctrl+C

In power BI use enter data to paste this table:

Paste as below and create a new dim Shift table:

Now just relate hour of this table with fact table's hour column with 1 to many relationship.

Use dim table columns as slicers in your visuals.

Hope it helps.