Power BI

Needs Votes

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

Vote (164)

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

Comments (20)

91c6bef5 24d4-ea11-a813-000d3a579c34 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.

81401c74 0ec6-ea11-a812-000d3a579c39 on 01 Aug 2020 13:53:50

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

An excellent idea!

12df8ccf edd3-ea11-a813-000d3a579c38 on 01 Aug 2020 11:56:57

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

Great

12df8ccf edd3-ea11-a813-000d3a579c38 on 01 Aug 2020 11:56:19

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

Great!

574e2249 e4d3-ea11-a813-000d3a8b3802 on 01 Aug 2020 10:49:18

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

Yes!

6d82718a e1d3-ea11-a813-000d3a8b3802 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!

ff84e1e6 dfd3-ea11-a813-000d3a8faea9 on 01 Aug 2020 10:17:36

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

Great idea

8a15b73c dad3-ea11-a813-000d3a8b3802 on 01 Aug 2020 09:39:48

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

Great 👍

8a15b73c dad3-ea11-a813-000d3a8b3802 on 01 Aug 2020 09:39:25

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

Great 👍

38f15a8f ccd3-ea11-a813-000d3a563be2 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.