113
When I combine measures and the content of a column in a matrix, I always get the visualization of all the combinations. For example:
- Measures: Sales Amount, Sales YOY%
- Year: 2020, 2019

The visual displays 4 combinations, producing the cartesian products of all the measures and all the years selected. It would be useful to create a list of the combinations required, such as:
( [Sales Amount], 'Date'[Year]."2020" ),
( [Sales Amount], 'Date'[Year]."2019" ),
( [Sales Amount YOY%], 'Date'[Year]."2020" ),

The primary goal would be to obtain the desired result in a Matrix, but this would be also useful for Table and other visuals, including charts.
STATUS DETAILS
New

Comments

M

This will go a long way to getting the most out of calculation groups.

M

This will make calculation group customizable and allow to control reporting what is required. Great idea.

M

A fantastic idea!

M

We run into this need constantly. Our workaround is to build models with complicated DAX queries on top of data models, which is inefficient and difficult to sustain. Please consider!

M

I agree, It could me very useful!

M

There would be one fewer reason to revert to Excel for analysis if this were integrated into Power BI.

M

This is a important feature must have in the Matrix

M

Definitely needed!

M

This needs to happen. It's one of the reasons stakeholders don't like to stop using Excel for reporting.

M

An excellent idea!