While creating a dashboard in Desktop i came across a requirement where the view filter needs to be applied to the grid level, not the level of the data set which seems to be the default behavior. Here is how you can change it in MicroStrategy Web (based on the documentation):
- Open your dashboard in Design Mode in MicroStrategy Web
- Right click on the grid to edit the view filter. Next to the filter you will see an arrow pointing up. If you hover over it gives you the info "Apply condition at the level of the report objects".
- Click on this arrow. It will change and point down. Hovering over it will say "Apply condition at the grid level", which is what you want.
UPDATE: You can change the behavior in Desktop too. You have to right click on the info symbol to order to change the level. I did not expect that...
Have a great weekend!