Hide measure value for empty row

[WSeirafi]

Hello,

My problem is pretty simpe but I couldn't find an elegant solution to it.

I have a direct query dimension generated according to the user and his security credentials. So some users won't have every row for this dimension. While the fact table is complete of course.

When I create a matrix with this dimension field and measure, the measure works fine with the rows he is allowed to see and will show the rest of the sales numbers in an empty line.

How can I avoid this ?

Regards

[v-easonf-msft · Accepted solution]

Hi, @WSeirafi 

Power BI matrix visual will auto-hide the records if the field value is blank.

Please check whether you have disabled the option ‘show items with no data’.

If it doesn't work, you can also consider applying a visual level filter in Power BI.

Applying a measure filter in Power BI 

Best Regards,
Community Support Team _ Eason