Forum Discussion

Incipient's avatar
Incipient
Icon for Helper I rankHelper I
4 years ago

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 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Incipient , You can try a measure like

 

Measure =

Switch( Max(Table[Attr]) ,

"Population", format(sum(Table[Value]), "#,###") ,

"Avg Pop Age", format(Average(Table[Value]), "percent")

)

 

Incipient's avatar
Incipient
Icon for Helper I rankHelper I
4 years ago

amitchandak Thanks for the suggestion!

 

Yeah a measure is my fallback, but it's very far from remotely good.

 

My data is a lot more complex than this, so the measure is not so straightfoward, and a functional issue is when users export data that has been converted to text with format(), the xlsx has all of the cells as 'text' not a number, so it heavily breaks usability in excel.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Incipient if you want the attributes to be filtered dynamically then amitchandak provided solution is the right one.

     

    As you are going to have all the formatting under one single measure, yes it will be text format and once you export it in excel you have to do the pivot.

    But yeah, i do understand your pain as i have gone through the same.

    But no any other way than doing as amitchandak given.