Forum Discussion
Matrix Visual - Single 'Values' field over multiple columns with different decimal places
I am using a Matrix visual with unpivoted data (attribute-value pairs). I have the 'attribute' in the "Columns" field, and the "value" in the values field' Quick example (with made up data!) has ...
Incipient create individual measures as below for the population and avg age
Population = CALCULATE(SUM(Population[Value]),Filter(Population,Population[Attr]="Population"))
Avg Age = CALCULATE(SUM(Population[Value]),Filter(Population,Population[Attr]="Avg age"))
Place it in Matrix visual.
Go to visual format and under the specific column category under Values, you can select the measure and do change the decimal places to 0 from auto to population and for avg age change it to 2.
Accept the solution if it works.
Anonymous Again, a useful suggestion on this sample dataset, unfortuantely I have up to 100 'attributes', and I need the matrix to dynamically add/remove the columns based on filters/selection.
Example here would be if someone selected filtered on "Asia" the Matrix would only show "Japan" (and remove the other columns).