Forum Discussion
Solved
Slicer - Multiselect
Good Evening All, A quick question from a PowerBI novice. I have a two slicers that are a filter for a variety of different projects. Slicer 1 drills down by projects in a specific location....
If I understand correctly, there are two slicers: Location and Team
If so, then you can take a look at the ISFILTERED or HASONEVALUE functions and combine with IF to display the totals or even specifics.
Something like:
measure = IF(ISFILTERED([Team]),
// show specifics
// show blanks or total
)
vicky_
Super User
Super UserIf I understand correctly, there are two slicers: Location and Team
If so, then you can take a look at the ISFILTERED or HASONEVALUE functions and combine with IF to display the totals or even specifics.
Something like:
measure = IF(ISFILTERED([Team]),
// show specifics
// show blanks or total
)