Hide Blank

[irfanelevated]

Hi,

I'm new to PowerBI, In Tableau it is very easy to hide a label.

How we can hide the blank label in the below image? I don't want to exclude it only hide it.

Please suggest.

[amitchandak]

@irfanelevated , in the visual level filter, put the Axis column as not blank

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter

[irfanelevated]

@amitchandak , I want to hide it,  not filter it. Is there any way to without a filter?

[amitchandak]

@irfanelevated , That is why I asking for the visual level filter.  What do mean by hiding then?

[irfanelevated]

@amitchandak  Actually on the top I have a KPI where I'm showing the Blank Total? So when I applied a visual level filter to exclude blank so click functionality stop showing the total for blank?

[v-jingzhang]

Hi @irfanelevated 

What do you mean by "click functionality stop showing the total for blank"? Do you mean when clicking either non-blank bar, the KPI visual displays (Blank) for the Blank Total? If so, you can avoid this by disabling the bar chart to filter the KPI chart so that the KPI chart is able to show the Blank Total all the time.

Steps: Select the bar chart -> Format -> Edit interactions -> None icon on the upper right corner of the KPI chart (I take card visual for example)

Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

Hope this helps.

Best Regards,

Community Support Team _ Jing Zhang

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