Forum Discussion
How to hide rows based on measure in simple table visual
@MattAllington You inspired me with the light to dig - all I had to do is set the filter as I want in PBI Desktop, then "lock" the filter so that it can't be changed by the end user and I also clicked on the little eye to cross it which means it won't even be presented to the end user filters panel (the other filters appear fine). I'm gold. Thank you. For your information, the PBI report is being consumed as an embedded PBI in SharePoint.
@MattAllington You inspired me with the light to dig - all I had to do is set the filter as I want in PBI Desktop, then "lock" the filter so that it can't be changed by the end user and I also clicked on the little eye to cross it which means it won't even be presented to the end user filters panel (the other filters appear fine). I'm gold. Thank you. For your information, the PBI report is being consumed as an embedded PBI in SharePoint.
Hi Boyan
Glad that you have solved this problem. You could accept the proper reply as the solution to close this topic and help others find the solution quickly. Thanks a lot.
Best Regards,
Community Support Team _ Jing Zhang