Forum Discussion

srkase's avatar
srkase
Helper IV
7 years ago
Solved

INDIAN 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 A...
Need Help
  • srkase's avatar
    srkase
    7 years ago

    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's avatar
    JosefPrakljacic
    7 years ago

    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?

  • srkase's avatar
    srkase
    7 years ago

    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's avatar
JosefPrakljacic
Solution Sage
7 years ago

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 Smiley Very Happy -> If you think that this post was helpful. Please share some Kudos 

  • srkase's avatar
    srkase
    Helper IV
    7 years ago

    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's avatar
      JosefPrakljacic
      Solution Sage
      7 years ago

      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's avatar
        srkase
        Helper IV
        7 years ago

        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..