Forum Discussion
Helper IData from diffrent table in matrix view.
Hi Everyone.
I have just started building reports so sorry if this has already been answered. I have tried to search for a solution but there is not really one that fits.
My users have a report in excel that has headings like this;
I already have tables with the data for each category (daily events, daily hours etc) but I can work out a way I can present the data in the same way as the excel table.
I thought about having a measure for each of the columns, but this seems like a hard way of doing this.
Any pointers to what I can try?
Thanks
2 Replies
- amitchandak
Super User
markdem , seem like measure above category, for that you have table where measures are also in rows and then you can get this format
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
markdemNot quite. The issue I have is that the 3 categories (daily events, daily hours and cancelation reason) come from 3 data feilds.
If I only select 1 feild I get exactly what I need (Activity type was selected);However if I add a second I get this get this (Activity type and Cancellation reason was selected);
I don’t want the cancellation reason to be grouped by activity type. I just need it to be separate like this (this is just two matrix tables on top of each other).
Thanks again.
