Power BI

Needs Votes

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

Vote (259)

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 (27)

Comments (27)

Francesco Bergamaschi on 01 Aug 2020 11:56:19

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

Great!

Erik Jonker on 01 Aug 2020 10:49:18

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

Yes!

Сергей Викторович Коломиец on 01 Aug 2020 10:30:16

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

Thats a great idea. I support!

Rui Afeiteira on 01 Aug 2020 10:17:36

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

Great idea

Shahzad Hanif on 01 Aug 2020 09:39:48

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

Great 👍

Shahzad Hanif on 01 Aug 2020 09:39:25

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

Great 👍

Bhavesh Patel on 01 Aug 2020 07:59:04

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

Great. We have so many users who is looking for same functionality.