cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HenryJS
Post Prodigy
Post Prodigy

Replace £0 with Hyphen

Hi all,

 

Is it possible to replace £0 with hyphens "-" in a table visual?

 

The data are currently showing as whole number currencies.

 

Capture.PNG

 

Thanks,

1 ACCEPTED SOLUTION
Tahreem24
Super User II
Super User II

@HenryJS ,

Create new measure like this:

Measure = IF(SUM('Table'[Currency])=0,"-",SUM('Table'[Currency]))
Then format it as Pound.
Capture.PNGCapture.PNG
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report

View solution in original post

1 REPLY 1
Tahreem24
Super User II
Super User II

@HenryJS ,

Create new measure like this:

Measure = IF(SUM('Table'[Currency])=0,"-",SUM('Table'[Currency]))
Then format it as Pound.
Capture.PNGCapture.PNG
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors