Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

drill through button on Timeline report

Hi team,   I am working on a timeline report where that doesnt have drill though option, So planned to pull a button for the same. but this button enable only when i click on the visual.  The requ...
Need Help
Tips and Tricks
  • AllisonKennedy's avatar
    AllisonKennedy
    6 years ago

    See the attached pbix file. I have not put any action on the button, but if you select a product in the table you should see the button appear. Consider the conditional formatting I've applied.

    If you have the measure grayed out as an option, this is usually because the data type does not match the formatting rules you are trying to apply. What is the data type of your Measure7?

AllisonKennedy's avatar
AllisonKennedy
Community Champion
6 years ago
Anonymous I'm not sure this functionality is built in, but you can have two buttons - one with Page Navigation to the page in question, one with Drillthrough that only activates when a specific item/time is selected. You can use the button features to change the disabled text of the button so that it says 'Select a feature in the timeline below' instead of 'Details' when nothing is selected.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons#customize-formatting-for-disabled-buttons
Anonymous's avatar
Anonymous
Not applicable
6 years ago

AllisonKennedy 

thanks for the quick response. it really helped. 

As you said i have created two button( one for drill though and other for page navigation) and place one botton on top of other and hide the drill though button when we havent select any visual items.

But here the page navigation button is enabled all the time so i cant click over the drill trough button.  so is there have any ways i can disable the page navigation button if i have selected any visuall item. 

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    6 years ago
    If you put them next to each other you might have better success than if they're on top of each other, but either way you can create a DAX measure to check if visual item is selected (use ISFILTERED or ISCROSSFILTERED and then the column name of the visual item)

    and use that to title/display the button with the fx under button Text.

    Does that make sense?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      AllisonKennedy 

      I have created a measure (Measure 7 = if(ISFILTERED(FactMileStone[feature_id]),"Details","") ) but it was not enabled to select in the contional formating 

      Both buttons

       

      Condtional format

       

      measure is disabled by default

       

       

      • AllisonKennedy's avatar
        AllisonKennedy
        Community Champion
        6 years ago
        Anonymous
        Sorry, your image is too small to see - it won't let you select Measure7?

        It works on my test and looks selectable in your small screenshot, but like I said your image is too small to see for sure if that measure is disabled. Your measure DAX looks right.

        I have used

        ButtonText = IF(ISFILTERED('Table'[Category]), "Details", "")

        In my testing