Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

drillthrough restrictions

Hi there,

 

Appreciate anyone's help on this! So I have a visual that shows scores for a few workstreams, I have a page for each one of these workstreams, I'd like to restrict drill through so you only have the option to drill through to the workstream page instead of having the choice to drill through to any of the workstream pages

 

This is the visual

These are the options I'm given when trying to drill through from the engagement bar, I'd like this to just show engagement

 

This is the page i'm drilling through to as well as the drill through columns it accepts

 

Thanks for your time on this, any help at all is appreciated 🙂

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    You can refer the following blog to achieve it:

    Conditionally Drill-through action in Power BI

    Step 1:  Create the DAX formula for the Button text and Destination as below.
    BtnDrillText =
IF (
    SELECTEDVALUE ( 'Profit Table'[Details], 0 ) = 0,
    "Drill",
    IF (
        SELECTEDVALUE ( 'Profit Table'[Details], 0 ) = "Product Revenue",
        "Drill to Product",
        "Drill to Actual Cost"
    )
)
    DrillDestination =
IF (
    SELECTEDVALUE ( 'Profit Table'[Details], 0 ) = 0,
    "",
    IF (
        SELECTEDVALUE ( 'Profit Table'[Details], 0 ) = "Product Revenue",
        "Product",
        "Actual Cost"
    )
)

    Step 2:  Map the created DAX in the button text and button action -> Destination

    Step 3:  Format the button to show the difference between disabled and enabled state.

    Step 4:  Give a meaningful tooltip for the disabled and enabled state. (If left blank, Power BI automatically generates tooltips) 

    Best Regards