Fixing Div Errors

Copper Contributor

Hi - I used the 'show values as' option within the data set of the pivot and now I get DIV errors that I don't know how to error out. Normally, I would write IFERROR formula but not sure how to do it since I used the 'show values as' option.Capture2.PNG

 

Capture2.PNG

1 Reply

@BevData 

Play with settings, for error values you may show blanks or any text you prefer.

image.png

If how to show the error depends on field (other words to show different values instead of errors) that's to add data to data model creating PivotTable and create your own DAX measure instaed of default aggregation (% Difference From).