Matrix with 2 dimensions in colums

[clem312]

Hi,

I have a matrix with 

In line = Ranking of my categories

In colums = Brands (only 2)

In measures : category name and value

Now I need to display the informations over 5 years. I wish I could add "Year" in colums just ahead of my two brands. But Matrix don't allow that. Anyone have an idea, how I can display these informations ?

[clem312]

Hi @lbendlin 

You are 100% correct. I read here that you could do that and expand if your data were correctly related :
https://community.powerbi.com/t5/Desktop/Double-Heading-Matrix/m-p/309886#M137213 

Thank you for your answer.

[lbendlin · Accepted solution]

The matrix should allow you to do that. Is your calendar table maybe not connected to the rest of the data model?  What error do you get?