Forum Discussion
How to Format Negative Percentages as (##) Instead of -## ?
Hi y'all,
Basically as title says, I want to format negative percentage values in my matrix as (5)% instead of -5%.
For context, The data type in my source data is Percentage.Type as well as set to Percentage under Formatting. Is there a way to do custom formatting, and if yes, what would the correct command for it be?
Hi,
There are some ways to achieve this, but one of ways is to setup format = Custom and write the format code under Property section of the visualization.
I tried to create a sample pbix file, and in the sample, I create table visualization.Please check the below picture and the attached pbix file.
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
3 Replies
Hi,
There are some ways to achieve this, but one of ways is to setup format = Custom and write the format code under Property section of the visualization.
I tried to create a sample pbix file, and in the sample, I create table visualization.Please check the below picture and the attached pbix file.
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
This was perfect thank you!
You can use the ABS function.
https://learn.microsoft.com/en-us/dax/abs-function-dax
