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

Timo Bauer on 13 Jul 2023 12:14:47

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

would be great and very useful

Marco Russo's profile image Profile Picture

Halid LAGUIDE on 21 Nov 2021 22:10:40

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

great

Marco Russo's profile image Profile Picture

Jürg Jenny on 05 Sep 2021 08:34:04

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

We need this feature.

Marco Russo's profile image Profile Picture

Elena Schott on 01 Jun 2021 18:35:04

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

Ideally this is an option for the visual itself, to specify yes/no by calculation group item if it is to be displayed, much as distinct series can be modified.

Marco Russo's profile image Profile Picture

CLEARIFY . on 10 Oct 2020 20:08:04

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

If you have groups of similar measures for say dollars and quantity e.g. MTD, YTD, Current, there is no way to combine MTD, YTD dollars and Current quantity in the same 3 column visual.

Marco Russo's profile image Profile Picture

Benjamin Dumourier on 08 Sep 2020 18:51:22

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

definitely need that

Marco Russo's profile image Profile Picture

Raymond Raviz on 26 Aug 2020 05:58:55

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

very useful!

Marco Russo's profile image Profile Picture

Tom Chelle on 07 Aug 2020 19:56:05

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

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

Marco Russo's profile image Profile Picture

Aditya Padisala on 06 Aug 2020 06:16:55

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

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

Marco Russo's profile image Profile Picture

Barrett Layman on 05 Aug 2020 13:57:22

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

A fantastic idea!