Forum Discussion

KasperJ90's avatar
KasperJ90
Icon for Helper III rankHelper III
3 years ago

Drill through on field parameter

Hi,

 

I have created a visual with fields parameters for the X and Y axis:

 

X Axis:

Year

Month

Customer

 

Y Axis:

Total Sales

Total Units

 

I want to add a drill through options to a detailed table. I tried to add another report with the X and Y parameters as drill through but I can not see it in my visual. 
How can I use fields parameters and drill through together?

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    KasperJ90 it should work assuming you don't have a filter on field parameters, or provide more details with the screenshots.

    • NeedhelpBI's avatar
      NeedhelpBI
      Frequent Visitor
      3 years ago

      parry2kit is working - but I need to move all the columns from my field parameter into the drill through field. I have 10 different field parameters in my selection, but now I just added them all one by one to the drill through area. I thought I could just move the X Axis table that was created with my 10 parameters to the drill through area, but then it is not working.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    NeedhelpBI I see what you are saying, afaik, I think you have to add all the columns from the field parameters one by one. Maybe this is something you can add as an idea on the ideas forum.