Forum Discussion
learninghard
1 year agoRegular Visitor
Multiple Values Column Order
Matrix Table Rows: Customer A, B, C... etc Columns: Jan 2024... to Dec 2024 Values: Revenue, Cost Result will show revenue and cost as a pair together for each month. Is it possible to show...
- 1 year ago
Hi learninghard
Unlike Excel pivot tables Power BI matrix values cannot be placed above the column hierarchy. To achieve this effect, the values must be materialized through a measure referencing a disconnected table with a column containing the measure names.
Please see the attached pbix.
If this isn't want you're looking for, please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.
Ashish_Mathur
Super User
1 year agoHi,
Share some data to work with. Share it in a format that can be pasted in an MS Excel file.