Sometimes your data isn’t shaped the right way. Have you tried the Pivot or Unpivot methods in Power Query? They can help get your data looking the right way for your Power BI reports!
Pivot columns
https://docs.microsoft.com/en-us/power-query/pivot-columns
Unpivot columns
https://docs.microsoft.com/en-us/power-query/unpivot-column