I basically want to add a "Week Of" level to my date hierarchy. I've created a new field that captures the Monday of whatever date is specified, but PowerBI has automatically detected it as a date and created a hierarchy. This makes me unable to add the date to the existing date hierarchy. Any suggestions?
Yes, it will turn off all existing date hierarchies. (that is actually how I work in all my projects. I much prefer creating my own columns in my date table and use those - especially relevant for week number and weekday number, where I need to specify the start day. for example, my weeks start on Monday, whereas PBI's default is Sunday)
Did I answer your question? Mark my post as a solution! In doing so, you are also helping me. Thank you!
@PaulDBrownThanks! I went ahead and did what you suggested. But how can I get the months to appear as the full month name instead of numbered months (January instead of just "1") while still maintaining the proper order?