Multiple Values Column Order

[learninghard]

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 all 12 months of Revenue together first, and then all 12 months of Cost after that? 

[v-ssriganesh]

Hello @learninghard,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @danextian for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

[Ashish_Mathur]

Hi,

Share some data to work with.  Share it in a format that can be pasted in an MS Excel file.

[danextian · Accepted solution]

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.