Forum Discussion

Jan845's avatar
Jan845
Helper I
3 years ago
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 the chart for each button, but i need the option when i click on buttons (like CTRL option) add data in just on chart and option to remove, like a filter its possible?

 

I need something like that:

Two button selected and one chart with students and professor data 

 

My PBIX file: WeTransfer - Send Large Files & Share Photos Online - Up to 2GB Free

Thank you for your time and the help 🙂

 

  • 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.

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Jan845 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's avatar
      Jan845
      Helper I

      @ Greg_Deckler

       

      I create one slicer , but i can't add my measure inside him