Conditional Drill Through Report on Power BI

[GuestUser]

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?

[v-lionel-msft]

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]

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]

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.