Forum Discussion
Helper IHide measure value for empty row
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
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
1 Reply
- v-easonf-msft
Community Support
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