Forum Discussion
Helper IIncrement data in chart with buttons
Jan845 Right, so use Type in your slicer. Then do something like this with your measures:
Measure = VAR __Selected = DISTINCT('Table'[Type]) RETURN IF("Student" IN __Selected, <your calculation goes here>, BLANK())Thus, each measure will return BLANK and thus no line if in this case Student isn't selected as a Type for example. This will have the effect of either showing or not showing each measure in your visual depending on the slicer selections.
Community ChampionJan845 Perhaps make your buttons a Horizontal slicer instead. You could then construct measures that either return BLANK or a value depending upon whether certain values are selected in your slicer.
Helper I@ Greg_Deckler
I create one slicer , but i can't add my measure inside him
- Greg_Deckler
Jan845 Is your Type a measure or a column?
- Jan845
My "Type" is a collumn , but my count of students and professores and externals are measure
- Greg_Deckler
Jan845 Right, so use Type in your slicer. Then do something like this with your measures:
Measure = VAR __Selected = DISTINCT('Table'[Type]) RETURN IF("Student" IN __Selected, <your calculation goes here>, BLANK())Thus, each measure will return BLANK and thus no line if in this case Student isn't selected as a Type for example. This will have the effect of either showing or not showing each measure in your visual depending on the slicer selections.