Forum Discussion
Matrix with 2 dimensions in colums
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 ?
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?
2 Replies
- lbendlin
Super User
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?
- clem312
Resolver I
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.