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)
    Marco Russo's profile image Profile Picture

    Christina Holmes on 05 Aug 2020 13:49:37

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

    We run into this need constantly. Our workaround is to build models with complicated DAX queries on top of data models, which is inefficient and difficult to sustain. Please consider!

    Marco Russo's profile image Profile Picture

    Michele Cattelan on 03 Aug 2020 17:37:47

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

    I agree, It could me very useful!

    Marco Russo's profile image Profile Picture

    Tate Bowman on 03 Aug 2020 13:05:25

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

    There would be one fewer reason to revert to Excel for analysis if this were integrated into Power BI.

    Marco Russo's profile image Profile Picture

    Saravanan Raju on 02 Aug 2020 14:20:59

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

    This is a important feature must have in the Matrix

    Marco Russo's profile image Profile Picture

    Roberto Franco on 02 Aug 2020 06:12:25

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

    Definitely needed!

    Marco Russo's profile image Profile Picture

    Andrew Machiano 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.

    Marco Russo's profile image Profile Picture

    Lance McKinnon on 01 Aug 2020 13:53:50

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

    An excellent idea!

    Marco Russo's profile image Profile Picture

    Francesco Bergamaschi on 01 Aug 2020 11:56:57

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

    Great

    Marco Russo's profile image Profile Picture

    Francesco Bergamaschi on 01 Aug 2020 11:56:19

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

    Great!

    Marco Russo's profile image Profile Picture

    Erik Jonker on 01 Aug 2020 10:49:18

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

    Yes!