Show "-" instead of 0 in Table View

[hyder]

Hello Everyone

MMy report is connected to an excel file, where in target column there are several values as 0. The same table also have a calculated column which takes data from a SQL Server DB n through a measure. Now in table view, I want to show the 0's as "-", like the accounting number format of excel. Is there any easy way to do so?

[Fowmy · Accepted solution]

@hyder 

Select the column or the measure, go to the Format option, and apply the below custom format:

0.00;-0.0;"-"

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn