INDIAN CURRENCY VALUE FORMAT

[srkase]

IN BI DESKTOP , MY VALUES ARE DISPLAYING IN INDIAN FORMAT.. 

EX 12,42,539

BUT WHEN I PUBLISH THE SAME TO DASHBOARD,

IT IS SHOWING AS 

1,242,539

I WANT TO FIX THIS ISSUE?

CAN ANY ONE PLS GUIDE

[srkase · Accepted solution]

YES JI... THATS WHAT I HAVE DONE... I HAVE FIRST FINISHED ALL THE measures and calculations... then applied this for the last step to display the value..

[JosefPrakljacic · Accepted solution]

And its still not working? Or is it working now - because if you apply format as the last step over your whole calculation - I don't see any reason why you should get a conversion error. 

Would it be possible that you provide us with more info to your data or better the pbix file?

[JosefPrakljacic]

Hello Srkase,

in Power BI Desktop I formatted the values like this here: 

Measure :=

VAR YourValue = SUM(Tabelle[Spalte "1"])

RETURN

SWITCH(TRUE(),

YourValue >=10000000, FORMAT(YourValue,"##\,##\,##\,##0"),

YourValue >=100000, FORMAT(YourValue,"##\,##\,##0"),

FORMAT(YourValue,"##,##0")

)

When I upload the report then it works and the correct format is shown. Does this solve your problem?

Very Important  -> If you think that this post was helpful. Please share some Kudos 

[srkase]

THIS OPTION CONVERTS THE FORMAT INTO A TEXT .  WHEN GOING COMPARISON BETWEEN THIS VALUE AND A NORMAL NUMBER IT GIVES ME AN ERROR THAT TEXT CANNOT BE CONVERTED  TO DATA TYPE...

[JosefPrakljacic]

Hello Srkase,

I get your point but what if you calculate your measures/comparisons when they are still numbers and apply the FormatFunction  as the last step in your calculation before kinda "showing it on the report" what would speak against that thing?

BR,

Josef

[srkase · Accepted solution]

YES JI... THATS WHAT I HAVE DONE... I HAVE FIRST FINISHED ALL THE measures and calculations... then applied this for the last step to display the value..

[JosefPrakljacic · Accepted solution]

And its still not working? Or is it working now - because if you apply format as the last step over your whole calculation - I don't see any reason why you should get a conversion error. 

Would it be possible that you provide us with more info to your data or better the pbix file?

[VaibhavShaktide]

Hi Josef,

How can we implement this in a bar chart ..so on Y axis I need to see the values ,but with a text field I wont be able to insert it onto the y axis.

[srkase · Accepted solution]

In the BI desktop it works good in the matrix view.. But when I applied the same in the online dashboard, the values are not displaying according to it.

[JosefPrakljacic]

Is it possible that you share your report? Because as you can see on my screenshot i used Power BI Service and it was showing the value as intended

[srkase]

[JosefPrakljacic]

I'm afraid you'll have to switch to ReportPage tooltips to solve the problem.

https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

BR,

Josef

[srkase]

Yes.. Jose.. it works fine now

[srkase]

sorry... In the matrix view's its working perfect...

But I have applied this measure in a tool tip of a chart. ... It doenst work there.

---

@srkase wrote:

In the BI desktop it works good in the matrix view.. But when I applied the same in the online dashboard, the values are not displaying according to it.

---