Maintain 0 values when filtering

Question

Hi Everyone!I have a table with two columns:&nbsp;Column 1: &nbsp; &nbsp; &nbsp; Column 2:Text 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Value 1Text 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Value 2&nbsp;Text 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Value 3Text 4. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value 4&nbsp;Then I have a Year Filter.&nbsp;The problem is that when I select a year that doesn't have a value for Text 4, Text 4 disappears from the vísual. I need to maintain this showing 0 value.&nbsp;&nbsp;Is it possible?&nbsp;Than you!

portrek · Accepted Answer

Hi.In case you using a measure, add +0 in the end the code.But if you have been using a column from table, click in the field data with the right button mouse and enable the option shows the image.&nbsp;&nbsp;Best regards

Forum Discussion

Maintain 0 values when filtering

2 Replies

Related content

Maintain Slicer Values through Bookmarks

Data Pipeline Maintain & Job Management

Maintain historical Data

Manually maintained datasets

Function Library - Create and Maintain