Skip to main content

    Power BI

    Needs Votes

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

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

    9879b8a8 db05-4b59-aa3d-bfc238e74b75 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

    335a1cd5 60e7-ea11-a817-000d3a8b3802 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

    a53bf171 e7d8-ea11-a813-000d3a8b3802 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

    26ee64d8 abd7-ea11-a813-000d3a9b112e 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

    c7157455 23d7-ea11-a813-000d3a579c39 on 05 Aug 2020 13:57:22

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

    A fantastic idea!

    Marco Russo's profile image Profile Picture

    401bcc9b a300-49e6-af97-41ad5ce60538 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

    599a5fb6 a0ce-ea11-a812-000d3a4e3654 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

    a971d60d 1e6d-4e7a-9723-22917ece362e 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

    d1f7264b 70c7-ea11-a812-000d3a4e3654 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

    8603e396 86d4-ea11-a813-000d3a8b3802 on 02 Aug 2020 06:12:25

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

    Definitely needed!