Forum Discussion
Jan845
Helper I
Helper IIncrement data in chart with buttons
Hi guys, I hope you are well I have one doubt . It's possible to add more data into a chart with buttons? My Dashboard I have 4 buttons with bookmarks action , when i click change...
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.
Greg_Deckler
Community Champion
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.
Jan845@ 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