Skip to main content

Power BI

Needs Votes

Selection of arbitrary combinations of measures and other table/column items in visuals

Vote (264) Share
Marco Russo's profile image

Marco Russo on 13 Jul 2020 09:57:13

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.

Comments (25)
Marco Russo's profile image Profile Picture

Christina Holmes on 05 Aug 2020 13:49:37

RE: Selection of arbitrary combinations of measures and other table/column items in visuals

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!

Marco Russo's profile image Profile Picture

Michele Cattelan on 03 Aug 2020 17:37:47

RE: Selection of arbitrary combinations of measures and other table/column items in visuals

I agree, It could me very useful!

Marco Russo's profile image Profile Picture

Tate Bowman on 03 Aug 2020 13:05:25

RE: Selection of arbitrary combinations of measures and other table/column items in visuals

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

Marco Russo's profile image Profile Picture

Saravanan Raju on 02 Aug 2020 14:20:59

RE: Selection of arbitrary combinations of measures and other table/column items in visuals

This is a important feature must have in the Matrix

Marco Russo's profile image Profile Picture

Roberto Franco on 02 Aug 2020 06:12:25

RE: Selection of arbitrary combinations of measures and other table/column items in visuals

Definitely needed!

Marco Russo's profile image Profile Picture

Andrew Machiano on 01 Aug 2020 18:32:48

RE: Selection of arbitrary combinations of measures and other table/column items in visuals

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

Marco Russo's profile image Profile Picture

Lance McKinnon on 01 Aug 2020 13:53:50

RE: Selection of arbitrary combinations of measures and other table/column items in visuals

An excellent idea!

Marco Russo's profile image Profile Picture

Francesco Bergamaschi on 01 Aug 2020 11:56:57

RE: Selection of arbitrary combinations of measures and other table/column items in visuals

Great

Marco Russo's profile image Profile Picture

Francesco Bergamaschi on 01 Aug 2020 11:56:19

RE: Selection of arbitrary combinations of measures and other table/column items in visuals

Great!

Marco Russo's profile image Profile Picture

Erik Jonker on 01 Aug 2020 10:49:18

RE: Selection of arbitrary combinations of measures and other table/column items in visuals

Yes!