Display values of 0 as dashes in a table visual?

[rmcgrath]

Hello.  In a table visual, I created several placeholder measures and gave them a value of 0.  For example, PlaceholderMeasure1 = 0

How can I make this value show as a "-" in the table visual?  Every formatting trick I've tried does not work.  Here is a screenshot:

Here is what I tried in the Modeling tab for the "Cash" elimination value:

Lastly, the entire column of Elimination values are filled in using a SWITCH measure:

Again - all of the measures in the SWITCH measure are placeholders for now (they are all set to = 0)

[Anonymous · Accepted solution]

Hi @rmcgrath ,

Here is the measure I created:

Measure = 0

Go to the Modeling tab, select the measure, and find the Format section in the Properties pane. Enter "-" as shown in the format text box.

The measure appears as "-" in the table visual.

If you want to learn more about this, please see:

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

If you have any further questions, please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!