Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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..
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.
Hello Srkase,
in Power BI Desktop I formatted the values like this here:
Very Important -> If you think that this post was helpful. Please share some Kudos
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...
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
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.
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
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
Yes.. Jose.. it works fine now
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |