Forum Discussion

rashel2002's avatar
rashel2002
Icon for Helper II rankHelper II
8 years ago

Struggling with adding a slicer

Hi Everyone!

 

i'm now trying to add slicer to a graph i created and it's not responding.

i have 2 tables - one is from the database and the other one is based on the first one, here's an example-

now, when i created the graph i did it with the right table, but now when i'm adding a slicer which filter by type(a/b) - the graph doesn't change when i press type 'a' only, for example. It's still presenting the situation as it is both type a&b.

i thought maybe it has something to do with the relationship between those two tables (cuz only the left one includes the type), but i don't know how to connect them in a way that the slicer will have impact.

 

here's what i want to get at the end when i filter by a for example- 

 

thank you guys.

Need Help

3 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    rashel2002,

     

    Drag [WW] from the second table and add measure to a Table visual. 

    Measure =
SUM ( Table1[Column2] ) + 0
    • rashel2002's avatar
      rashel2002
      Icon for Helper II rankHelper II
      8 years ago

      Hi,

      thank you for responding.

      i'm not fully understand it -

      what should i write instead of column2? and instead of table1 ?

       

      basically all i want is that the calculated column i created in the right table (the one that based on the right tablt) - will cbe dynamic and will calculate again as i press the slicer type. 

      i mean. i want the graph i creatd to change each time i press the type (a/b/a+b).

    • rashel2002's avatar
      rashel2002
      Icon for Helper II rankHelper II
      8 years ago

      i'll explain myself again :)

      lets say i have the database table, which explain me for each task - on what WW it happened and how many hours took for it to be done. also, for each task it tells me the priority of the task - 1(top priority), 2(low priority).

       

      now i want to creat a graph that will show me how many hours of work needed in each WW - but in a comulative way.

      so if my original table i extracted from the database was something like this-

      what i want is to creat a new table that will summerize for each week the effort (by hours) that was made on that week.

      now i want that column (that is summerizing the effort made each week) to be calculated dynamic and change by the filter selection, so that if i will press type 1+2, i will get something like that-

       

       

      but, if i perss only proprity '1' i will get something like that-

       

      so i want both of the columns "sum of hours" & "cumulitive" to be calculated dynamic and change by the filter selection, then the graph will change as well.

       

      thanks a lot!