Power BI
Needs VotesSelection of arbitrary combinations of measures and other table/column items in visuals
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)
RE: Selection of arbitrary combinations of measures and other table/column items in visuals
definitely need that
RE: Selection of arbitrary combinations of measures and other table/column items in visuals
very useful!
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.
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.
RE: Selection of arbitrary combinations of measures and other table/column items in visuals
A fantastic idea!
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!
RE: Selection of arbitrary combinations of measures and other table/column items in visuals
I agree, It could me very useful!
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.
RE: Selection of arbitrary combinations of measures and other table/column items in visuals
This is a important feature must have in the Matrix
RE: Selection of arbitrary combinations of measures and other table/column items in visuals
Definitely needed!