How to display only certain information in the dashboard?

[ShahbazovT]

Hi experts. I need your help 

I want to hide last row in dashboard

I used this formula:

=If(match([PORTFOLIO__LINE],'Retail'),Dual('Retail LP',0),
If(match([PORTFOLIO__LINE], 'corporate'), Dual('Corporate LP',1),
If(match([PORTFOLIO__LINE], 'SME'),Dual('SME LP',3),
If(match([PORTFOLIO__LINE], 'RETAIL'),Dual('Plastic Cards',4),
If(match([PORTFOLIO__LINE], 'Individual TD'),Dual('Individual TD',5),
If(match([PORTFOLIO__LINE], 'Legal TD'),Dual('Legal TD',6),
If(match([PORTFOLIO__LINE], 'Retail CA'),Dual('Retail CA',7),
If(match([PORTFOLIO__LINE], 'Corporate CA'),Dual('Corporate CA',8),
If(match([PORTFOLIO__LINE], 'SME CA'),dual('SME CA',9)))))))))) 

But i can't hide.

Please help 🙏

[tm_burgers]

You should be able to Uncheck "Include Null Values" on your dimension Bar.