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.
Hi,
I have created Dashboard using Matrix Dashboard for showing Financial Statements. When I'm tried to use DAX i.e. Format(abc,"0.00%") to show % sign along with Values but it gives following error.
Error:
My requirement is i want to show Values along with % Example: 26% without disturbing other rows.
Please guide me how I can achive to show values with percentge sign for specific row.
Thanks & Regards,
Pramod
Solved! Go to Solution.
Hi @v-supportlfspl ,
Remove the last ) in your formula and you don't need to *100 in your formula and use "0%" in your formula . For more details, please refer to https://www.tutorialspoint.com/dax_functions/dax_format_function.htm
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Dedmon Dai
Removed ")" from formula & used dax of Format function, but still not get % sign.
Please suggets any other solution.
Regards
Pramod
Hi @v-supportlfspl ,
Remove the last ) in your formula and you don't need to *100 in your formula and use "0%" in your formula . For more details, please refer to https://www.tutorialspoint.com/dax_functions/dax_format_function.htm
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
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.