Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Handling Negative Entries in Data

Hello community members, I have an Excel timesheet with data on the daily work hours of employees for different projects. I am creating a Power BI dashboard to display this information. However, s...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , In power BI use a measure = Sum(Table[Hours]) , with all other column

 

Also, you can use visual level filter measure <> 0

 

or anew measure

 

measure 1=

if([Measure] =0, blank(), [Measure])