Forum Discussion

PradeepDive's avatar
PradeepDive
Icon for Helper II rankHelper II
6 years ago

HASONFILTER doesn't work with Slicer

Hi All,   I am creating a drillthrough button in my report and for which I am using HASONEFILTER to see if a filter is applied or not. I also have a slicer (dropdown) in my page. Basically what th...
Need Help
  • PradeepDive's avatar
    PradeepDive
    Icon for Helper II rankHelper II
    6 years ago

    Thanks Amit,

     

    I have tried  ISFILTERED as well as HASONEFILTER but both are not working with drill through button if I select is through slicer (dropdown OR list). 

     

    Wried thing is if I add it as a simple table or matrix table and select it works...

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

      Hi PradeepDive ,

       

      If you want to drill through to the detail page when you select in a slicer, Power BI cannot support to jump to detail page.

      Drill Through will appear when you right-click the filed on Visual.

       

      You can refer to the following documents.

      https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons

      https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

       

       

      The function of the MyDrillthrough Navigation measure is that when ORG is selected, the corresponding row will display the Details Page, and the remaining rows will be empty, and there is no jump function.

       

       

       

      If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

      It will be helpful if you can show us the exact expected result based on the tables.

       

      Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

       

      Best regards,

       

      Community Support Team _ zhenbw

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