Forum Discussion
Multiple Values Column Order
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.
Super UserHi 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.