Skip to main content

Power BI

Needs Votes

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

Vote (263) 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)

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

Thats a great idea. I support!

Marco Russo's profile image Profile Picture

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

Marco Russo's profile image Profile Picture

Shahzad Hanif on 01 Aug 2020 09:39:48

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

Great 👍

Marco Russo's profile image Profile Picture

Shahzad Hanif on 01 Aug 2020 09:39:25

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

Great 👍

Marco Russo's profile image Profile Picture

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.