Forum Discussion

GuestUser's avatar
GuestUser
Icon for Helper V rankHelper V
6 years ago

Conditional Drill Through Report on Power BI

Hi,

 

Just want to know whether this is possible

 

I have a report in Power BI (SSAS Tabular- Connect Live Mode)

 

Table View : Report 1 have these two columns 

Itemname     RequestQuantity

A                     4

B                     10

C                     20

D                     2

 

Need to give a drill through report(navigate to new report) only on Items having requestQuantity greater than 5

Is this possible?

 

 

Need Help

3 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi GuestUser ,

     

    Yes, you can. The ‘Drill through’ feature can be used even in ‘Live Connection’ mode.

    For how to use this feature, you can refer to here.

    Use cross-report drillthrough in Power BI 

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • GuestUser's avatar
      GuestUser
      Icon for Helper V rankHelper V
      6 years ago

      Thanks !!

       

      But i was asking can we drill through on specific rows(values) only?

      like conditional navigation? only for values greater than 5?

       

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi GuestUser ,

         

        Try to do like this.

        (Please refer to the .PBIX file.)

        1. Create a calculated column like this.

        Column = 
IF(
    [RequestQuantity] >= 5,
    "x",
    BLANK()
)

        2. Add to target page.

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.