Forum Discussion
Solved
Increment 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.
My "Type" is a collumn , but my count of students and professores and externals are measure
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.