Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

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

    Vote (253) 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!