Changing hierarchy in visual gives wrong values

Hi KobeDel 

You can try checking the following points

1. Verify Hierarchy Setup: Ensure your date hierarchy is correctly set up in the model. Each level of the hierarchy (Year, Month, Week) should be correctly defined. 

2. Check Data Model Relationships: Ensure that the relationships between the tables (if your date fields are spread across different tables) are correctly established. Incorrect or missing relationships can lead to unexpected results when drilling down. 

You want the data to be ordered weeks first by year and then by week number, you might need to create a custom column that combines the year and week number into a single value that can be sorted numerically. Here's a simplified action plan:

1. Create a Custom Column: In Power BI Desktop, go to the Query Editor, and create a new custom column that concatenates the year and week number into a single value. For example, for year 2021 and week 5, the custom column value could be 202105. This ensures a sortable numeric value representing both the year and the week.

2. Sort by the Custom Column: Use this custom column as your sorting column in the visual. This approach ensures that your weeks are ordered first by year and then by week number, as intended.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.