Forum Discussion
Helper VMeasures filter
yeah, you can create a user-selected parameter via the Modeling tab, New Parameter. Then use SELECTEDVALUE() in a measure to see what the user has selected, and in turn, use that measure as a filter measure.
Helper VThank you very much for your help on this edhans and GilbertQ .
I have 5 visuals and 4 filters in same page.
With your step, it is working for one filter, but how can I activate for other 4 filters and 5 visuals? should I apply the same filter in all visuals for this?
And also visuals are not updating when I apply on filter. But filter is showing range of projects which I need.
Thank you
Community ChampionFiltering the slicer will not cause it to filter the visuals. You have two options:
- Apply the same measure filter to your other visuals
- Modify the slicer to force single selection so "nothing" cannot be selected. That will enforce the filter.
You will need to apply this method to every visual you want to be affected. You cannot do measure visuals on a page, only a per-visual basis.
A final alternative is to filter the data at the source through a filter in Power Query, or create a Calculated Table in Power BI using FILTER() or CALCULATETABLE() that only has this data and create your visuals on that table.
- Sudhavi_84
Thanks edhans
Got you. Is there anything alternatively as well create parameters and user can select the range with that it will update all 5 Visuals?
If not, I will choose one of the same above steps as you specified
- edhans
yeah, you can create a user-selected parameter via the Modeling tab, New Parameter. Then use SELECTEDVALUE() in a measure to see what the user has selected, and in turn, use that measure as a filter measure.