Forum Discussion
How to do a matrix table just like excel
Hello All,
I'm new to Power BI, and I know that Power BI is good at data visualization, but I have doubts when I transferring one excel chart to Power BI.
I prepared an excel chart like below, and it contains two databases, one is production, the other is sales. the production and sales databases are both made up of ABC.
My doubts are listed below:
1. how can I show the quarter details in some years but not in all years like above? because if I drill on columns, all the years are going to show quarterly details, which I don't need.
2. how can I show only total sales, but not with ABC breakdown. I'm thinking about making another matrix of sales, and narrowing the height to hide the breakdown from the apperance. but in this way, if the user drills on the columns of production matrix, he has to manually drill on the sales matrix again to be in line with production matrix. How can I combine these two matrix together? Also, for the new measure Sales/Production %, if I put this new measure in the same matrix of sales, two columns insteand of two rows will be displayed in each year. Can I change the setting of the matrix to let it show these two measures in two different rows?
3. I created the measures like vs. last year, vs. last quater, vs. y-o-y, but all the years display these measures which I don't want. as the chart above, I only want to show the comparison of these three kinds, can Power BI enable this function?
Thanks a lot for your help on this! I'm quite sorry for raising 3 questions in one post.
1 Reply
- v-frfei-msft
Community Support
Hi Anonymous,
For 1&2, based on my test, neither of them could be achieved in Power BI. You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.
For the third one, you can create different measures and show the measures in the card visuals to work around.
Regards,
Frank