Can a slicer ignore the column and associated rows on a table?

[Jamhan]

Hello,

I have a join table with a set of static names called members.

I also have another set of data that contains hours and task information. The information on these are respresnted in a table visual.

e.x.

Iteration: All

|Members|Completed Hours| Tasks|

|Dave       |                        0.0|          |

|Greg       |                        0.0|        1|

|Anne      |                        3.0|         3|

Whenever I select an iteration for the data with a slicer, it removes members without any associated information.

e.x.

Iteration: December

|Members|Completed Hours|Tasks|

|Greg       |                        0.0|      1|

|Anne      |                        1.0|      1|

When the slicer is set to all, it returns all of the members. I want it to retain the list of members but update the completed hours and tasks.

ex:

Iteration: December

|Members|Completed Hours| Tasks|

|Dave       |                        0.0|          |

|Greg       |                        0.0|        1|

|Anne      |                        1.0|         1|

Is there any way to have a slicer ignore filtering just that one column containing member names?

Thanks for any help,

It's definately appreciated.

[dax]

Hi Jamhan, 

If possible, could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

You can change the values that are null to be zero or blank.

---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."