Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Drill through based on one column

Hi All,

 

I would like to drill based on one column alone.

 

I have 3 column System Name, Week and Count. If i select any row then it should show its "system Name" relevant details.

Actual Table:

I have placed the actual table in main table.

Then created another page i.e., Drill through page.

in that table i want the expected table as below screenshot:

If i select row which contains A in system name column in first page then it should return A details i.e., System Name = A and Count = 6

 

Note: I am not giving week column in the drill through table due to some req.

 

If i select row which contains B in system name column in first page then it should return B details i.e., System Name = B and Count = 15

 

If i select row which contains C in system name column in first page then it should return C details i.e., System Name = C and Count = 24

 

The problem here is i am getting additional filter in Drill through Page. How to avoid that?

If i select first row in Page 1 then i am getting additional filter in drill through page Week is 1 to 10. Thus the count is showing 1 instead of that i want count as 6 when i select the first row.

 

In other words it should not get filtered by week column. It should only get filtered based on System Name (Similar to all and allexcept function but i want in drill through page.

 

Thanks

Prakash

  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous you should turn off Keep All Filter - Off  under Drill Through

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

2 Replies

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User

      Anonymous you should turn off Keep All Filter - Off  under Drill Through

       

      I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

      Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.