Don't show row with no data

[beekee]

Hi All,

I have a 'customised' matrix table that looks like this, able to display week, month, total columns that fall under FY21-Q4. However, I do not want to show the row where the Total is 0 or "-". Does anyone know how I can achieve it? Also, I'm not sure why there is an empty 3rd row showing in my table, I'd like to remove that row as well.

I have attached the sample pbix here: https://www.dropbox.com/s/wn99p8m6c4q1xrw/test1.pbix?dl=0 

Regards,

BK

[AlB · Accepted solution]

Hi @beekee 

1. Create this measure

ShowMeasure = 
VAR aux_ = CALCULATE([ActlPlan_Rev_Range], ALL(_ParaPeriod[Para Period]))
RETURN
IF(aux_<>0, 1, 0)

 2. Use the measure as visual filter, seelcting to show when value is 1

See it all at work in the attached file.

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.