Forum Discussion
Helper IVINDIAN CURRENCY VALUE FORMAT
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
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..
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?
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.
12 Replies
- JosefPrakljacic
Solution Sage
Hello Srkase,
in Power BI Desktop I formatted the values like this here:
Measure :=VAR YourValue = SUM(Tabelle[Spalte "1"])RETURNSWITCH(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 
srkaseTHIS 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