Filter using slicer without affecting the x axis of the chart

[NaveenMD]

My main issue is that when I try to filter the table using a slicer I end up filtering values in x axis this causes loss of information in the chart.

I need a dax where when I to filter a category using slicer except the selected category values of all other category is replaced by zero.

This will help me retain the value in x axis and remove the value from y axis as the value for the unselected category becomes zero.

@amitchandak  please help.

[Anonymous · Accepted solution]

Hi @NaveenMD ,

I made simple samples and you can check the results below:

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[Ritaf1983]

Hi @NaveenMD 

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