How to not show legend values for 0 value categories

[prathameshw]

I have to create a dashboard where I my x-axis has all years and y-axis has all the categories. (see below). The categories will not always have values and will be 0. When i plot the legend, it shows all the values even if 0 or not 0. How can I only show non-zero categories in the legend and hide 0 categories?

My table looks something like this

Any help will be appreciated. TIA

[Moetazzahran · Accepted solution]

Hello, 
You can use a measure which has the following formula.

Legendexclude = Switch(True(),MAX('Table'[Value])<>0,1,0)

 This is how the base table I used looks like.

Please let me know if this works properly in your case. If this solves your requirement, please accept it as a solution. You kudo is much appreciated.

You can use this post as a reference as well. 
Solved: Re: Legend - Too many Values -- How to hide legend... - Microsoft Fabric Community

[prathameshw]

Thanks. I had to reorganize the table (unpivot) but this is a great workaround.

I have an issue here. I dont see negative values, I only see positive. Why is that?