Forum Discussion
undefined
Hi
I need a help on matrix in Power bi. I have two dimensions revenue and expense from two different dimensions tables.
Matrix should show:
Revenue. Year. Amount
Cost centre 1
Cost centre 2
Revenue id
X
Y
Z
Expense
Cost centre 1
Cost centre 2
Expense id
X
Y
How can I show both
Z
First of all, please provide more information about your data model. Based on the details you have shared, I assume you may need to create a bridge table by combining all the IDs from the revenue and expense dimensions.
I have given it a try, and below are the file and screenshot for your reference.
Hope it will work. If it is not, please provide more information about your data and data model.
Regards,
sanalytics
5 Replies
Hi Swa_rna
Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Alternatively, you can share your .pbix via some cloud service and paste the link here. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.
Need help uploading data? click here
Want faster answers? click here
First of all, please provide more information about your data model. Based on the details you have shared, I assume you may need to create a bridge table by combining all the IDs from the revenue and expense dimensions.
I have given it a try, and below are the file and screenshot for your reference.
Hope it will work. If it is not, please provide more information about your data and data model.
Regards,
sanalytics
Data view → Select date column → Modeling ribbon → Sort by Column → choose proper date column (not text). Republish.
