How can I remove Blank column from Dynamic Column Selection?

[TehKonnos]

Hello!
I have created a Dynamic Column Selection to use in a slicer (The slicer uses a dropdown with single select). When the user selects an option, I count all the results splitter by the values of that option. 

I want to exclude blank values, for all that options, but when I try to do that via the visual, the results affect all other options from that slicer.

I.E. If I remove the blank results from Option 1, then option 2 will contain all related data, without the Blanks from option 1 that got excluded. 

I guess the proper solution has to do with the measure that counts the results, and not with the Dynamics Column, but I don't know exactly how to manipulate that with DAX.

Any ideas?
Thank you in advance

[Anonymous]

Hi  @TehKonnos ,

Do you mean that when you select an option, the corresponding blank data will not be displayed.

You can set value to is not blank in Fiilter.

If it doesn't meet your desired outcome, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

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

[TehKonnos]

@Anonymous @Ritaf1983  I have replicated my issue with demo data. 
In the example below, follow these steps:
1. Check how many rows exists on the right diagram, when the filter is Shirt Number

2. Change to Coffee Preference and try to exclude Blanks from the visual on the right

3. Return slicer to Shirt Number and check how the data are affected. 

The issue is that when you exclude Blanks from the Coffee Preference, you miss the truth about other categories, in our case, Shirt Number, where the value "Large" does not exist.

Link to file: https://drive.google.com/file/d/1xevTPkEJiUiVj5z87P8CJBki5PFFoIcw/view?usp=drive_link

[Ritaf1983]

Hi @TehKonnos 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523