Keep Categories in Table after Filtering

[Duncan-legend]

Hi all,

In this case, I have a table visual to show the no. of project by categories. However when i apply some filters, the visual become empty. How can I keep the categories in the visual after filtering.

Before Filtering:

After  Filtering:

Best regard,

Duncan

[Ritaf1983]

Hi @Duncan-legend 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

[Duncan-legend]

I make some dummy data for you.

 Test.pbix

[Ritaf1983]

OK. Could you please elaborate on the expected results? At present, the table is filtered based on type. Consequently, when 'C' is selected, the visualization is empty due to the absence of any rows classified as type 'C' within the dataset.

This is the typical slicer functionality. What kind of customized slicer behavior are you looking to achieve?

[DuncanYeah]

Hi,
Thank You. 
I want to keep the categories information even there are no data 

[Ritaf1983 · Accepted solution]

Hi @DuncanYeah 
You can create a disconnected table for the slicer 

slicer = DISTINCT('Table'[Type])

and create a measure :

Result:

PBIX is attached

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