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.
Hello,
I have some measures formatted with thousand separator and percentage but the tooltip is not showing them correctly formated.
Any tips to fix this? On power bi report server october 2020
Thanks,
João
Solved! Go to Solution.
Hi @Anonymous ,
As @amitchandak said, you could format measure directly in Format Pane-->Measure tools as shown below:
Or you could use FORMAT() function in DAX like this:
percentage in DAX =
FORMAT ( <value>, "#.00%" )
thousand separator in DAX =
FORMAT ( <value>, "#,###" )
Please take a look at the pbix file here.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
As @amitchandak said, you could format measure directly in Format Pane-->Measure tools as shown below:
Or you could use FORMAT() function in DAX like this:
percentage in DAX =
FORMAT ( <value>, "#.00%" )
thousand separator in DAX =
FORMAT ( <value>, "#,###" )
Please take a look at the pbix file here.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Formatting done under measure/column tools or under properties of Model view should work
Option 1
Option 2: https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
You should be able to do that in the format options for that measure once it is highlighted. You can also use custom format strings.
Use custom format strings in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |