Forum Discussion

mattymc1984's avatar
mattymc1984
Advocate I
8 years ago

Number formatting in Multi-Row Card

Hi,   I'm presenting some headline performance stats within multi-row cards (I had used indiviual cards, however they don't show the headers on mobile view), but I cannot find anywhere to change th...
Need Help
mattymc1984's avatar
mattymc1984
Advocate I
8 years ago

Hi Eric,

 

Thanks for the response.

 

I don't want to create a "blanket" formatting for a whole measure.  In my summary I want to show  in #.##M, but in a table I would want to show as #,###,###.

 

A standard "Card" visualisation gives you the following formatting options:

 

 

I was hoping to find I similar set of options for the multi-row card.

 

In the meantime, I have found a workaround by creating a custom measure:

 

       =CONCATENATE(TRUNC([value name])/1000000,2),"M")

 

This however, is not ideal as it means I need to create a custom measure for every value I wish to summarise in a multi-row card.

 

As I said, I would prefer to use a standard card, but at the moment these don't show headings on mobile view (already raised in another post).

 

Thanks,

 

Matt

 

NGTaylor's avatar
NGTaylor
Advocate I
8 years ago

I have exactly the same issue if anybody does find a solution.

 

Many thanks,

Neil

  • vanessa's avatar
    vanessa
    Post Patron
    8 years ago

    I am using a metric of type text in a multi-row card visual. But the formatting isn't working for it. The formatting works when the metric type used is numeric. 

     

    Is this a limitation of this visual?