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!
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.
Please share and describe what you have tried so far and what the results were so that we can try to help you.
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.
Try formatting it like this:
#,##0, “L”
#,##0, “Cr”
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
Do I need to add calculated field based on this calculation?, or I have to apply this formula in display format of the metric?
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.
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.
