Changing the display units of a kpi indicator

[GLIDO]

Hello community users, 

Any ideas on how to fulfil this, 

I have to set the display units for the KPI indicator to crores as I've to show them in indian standard. 

Can anyone help with this. 

Regards

Nilesh  

[Anonymous]

@GLIDO,

You can create a calculated column to format the number to display in indian standard. But the column is in text type, it is not possible to use it in KPI  visual.

Regards,

Lydia

[GLIDO]

Or we can just put the tiltle of the KPI indicator as Amount(in Crs) and then divide the figure with 10000000. 

In this case, can we dynamically change the name of the title, 

for examaple I create a mesure "division factor" with value 10000000 initially to show the amount in Crores and the change it to 100000 to show the amount in lakhs, here I need the title of all KPI's to be changed to Amount(in Lacs) instead of Amount(in Crs). 

Is there a way to achieve this @Anonymous ?

Regards 

Nilesh  

[Anonymous · Accepted solution]

@GLIDO,

Yes, you can. You would need to create a measure using similar DAX as below, then drag the measure to Card visual. If you need to change title based on slicer selection, you can refer to this blog.

DynamicTitle = [Measure] & "lakhs"

Regards,
Lydia

[Anonymous]

@GLIDO,

Based on my research, 1 Crore equals to 10 million. We are able to change the format of numbers to display ₹, but it is not possible to show number in crore format. You can submit a feature request in Power BI ideas forum.

Regards,
Lydia

[GLIDO]

Hi @Anonymous

Thanks for the information. 

Do we have a workaround for the purpose ?

Regards

Nilesh