Custom Number Display Format in Looker Studio (Formerly Google Data Studio)

[Munavvar21]

Can someone please help, how can I replace Million and Billion notations (M & B) to Lacs and Crores notations like L and Cr for metrics and dimensions in Looker Studio.  I have shared screenshot below and also shared from where we can change this but I don't know how to use formatting styles. Please help me!

want to change K, M & B notations to L and Cr

@lauratilton 

@Mehdi_Oudjida  @DaniCanhameiro  @kdimitrof  @mvdries 

@Emma_Docs 

@LookerStudious

@LookerStudioFan 

[marcwo]

Hi

custom number format follows Google Sheets style notations that are explained here.

Thanks
Marc

[Munavvar21]

It's not working as expected (probabely for google sheets, there are limitations in google looker studio for that). I have already went through this.

[marcwo]

Please share and describe what you have tried so far and what the results were so that we can try to help you.

[Munavvar21]

I have shared the screenshot above. For you, I have shared the snap again, in this comment.

It's a Line chart of google looker studio, the Y Axis represents K (for Thousand Seperators) and M (for Millions) instead I want Lacs (to be denoted by L) and Crores (to be denoted by Cr).

means I want to achieve 1,00,000 as 1 L and 1,00,00,000 as 1 Cr. Just like below there are 2M, 4M and 6M horizonal grid. 

[DaniCanhameiro]

Try formatting it like this:

#,##0, "L"
#,##0,, "Cr"

[Munavvar21]

Here's what I got

[DaniCanhameiro]

I tested it this way and it presented, but only one option.
#,##0 L

I found this another option, but I didn't test it. see if it works for you.

CASE
WHEN valor >= 1000000000 THEN CONCAT(ROUND(valor/1000000000, 2), " Cr")
WHEN valor >= 1000000 THEN CONCAT(ROUND(valor/1000000, 2), " L")
ELSE valor
END

[Munavvar21]

Do I need to add calculated field based on this calculation?, or I have to apply this formula in display format of the metric?

[DaniCanhameiro]

this option is to create a calculated field

I've never needed to do this formatting so I don't have the experience... but it's
Give it a try and see if it works for you.

[Munavvar21]

Not working either.... the metric is "TOTAL INVOICE VALUE", I have tried the above formula (replaced valor with "TOTAL INVOICE VALUE") but nothing worked, instead the dashboard stopped displaying the table.