Show Chart Columns as 0 if is blank when slicer selected

[YerlaSDU]

Hi Folks,

Please help me to resolve the task.

I have chart with 3 status columns, table and slicer.

If i select any item from table, chart shows correctly as 0 if is blank, see example

But if I select from slicer, it hide columns where is 0 or blank

How can I set up chart, so it will show 0 if is blank when slicer selected? 

[Anonymous · Accepted solution]

Hi @YerlaSDU ,

I think you can change the interaction between slicer to your column chart from cross-filter to cross-highlight.

Format>Edit interaction

For reference:

Change how visuals interact in a report - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

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