Hide item with no data in visual in the Power BI

[Analitika]

Hi,

I would like to ask how I could hide some elements in visual if some contains zero data. For example, I have line and clustured column chart. Lines are in y axis, so I can't change options for it.

Here is a visual:

Here I market Sales / h (2021) it contains null data. So I need to hide it, but I can't do it. How I can solve it? Main point to avoid not neccessary items in legend.

[DOLEARY85]

Hi, 

could you add a filter to the visual where the value is greater than 0?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Analitika]

When I filter value > 0 then visual became empty. No, that not helped.

[DOLEARY85]

Can you show me the filter pane and fields used? or are you able to share the PBI file?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Analitika]

I can't share PBIX file, filter pane looks like this:

Visual:

[DOLEARY85]

Sorry, can i see all the fields used in this visual?

[Analitika]

Visual:

Fields:

[DOLEARY85]

It's quite difficult to determine all the calculations involved without the PBI file, but i think if you created a duplicate of the table and unpivot the fields used in the visual then joined that table to the the current one.

You could potentially use the value field in the unpivoted table as a filter in the visual to remove anything that is not greater than 0.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Analitika]

I have no created a duplicate. Measures are created based on same table.