Enable conditional drillthrough

Hi there! I’d be happy to help you with your Power BI requirement. To achieve conditional drillthrough that dynamically includes the selected year and its previous year, you can follow these steps:

1. Create a Drillthrough Page:

   • Add a new page to your report and set it up as a drillthrough page.
   • Add the visuals you want to display on this page.

2. Add a Year Slicer:

   • On your drillthrough page, add a slicer for the Year column.

3. Create a Measure for Previous Year:

   • Create a measure to calculate the previous year based on the selected year. You can use DAX to achieve this:

     PreviousYear = SELECTEDVALUE('YourTable'[Year]) - 1

4. Add a Drillthrough Filter:

   • Add the Year column to the Drillthrough filters well on the drillthrough page.
   • Add the measure you created for the previous year to the Drillthrough filters well as well.

5. Set Up Conditional Filtering:

   • Use a DAX formula to create a new column that combines the selected year and the previous year. For example:

     CombinedYears = 
     VAR SelectedYear = SELECTEDVALUE('YourTable'[Year])
     VAR PreviousYear = SelectedYear - 1
     RETURN
     IF('YourTable'[Year] = SelectedYear || 'YourTable'[Year] = PreviousYear, 1, 0)

   • Use this new column as a filter on your drillthrough page to ensure it shows data for both the selected year and the previous year.

6. Enable Drillthrough:

   • On your main report page, ensure that the drillthrough functionality is enabled for the Year column. Users can right-click on the Year slicer and select Drillthrough to navigate to the detailed page.

Unfortunately, I can’t provide a sample .pbix file directly, but you can follow these steps to set it up in your own Power BI report. If you need more detailed guidance or run into any issues, feel free to ask!

Is there anything else you need help with?

OR PLEASE FOLLOW BELOW LINK ... I HOPE THIS WILL HELP YOU.

Solved: Is there a way to drill trough based on conditions - Microsoft Fabric Community

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Use cross-report drillthrough in Power BI Desktop - Power BI | Microsoft Learn

Set up Drill-through Pages in your Power BI Reports | Zebra BI Knowledge Base

Power BI Desktop May 2020 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

I hope this helps!
If you found this answer helpful:

Mark it as the solution to help others find it faster.
Give it a kudo to show your appreciation!
Thank you for being an awesome community member!

Hi , Hope you are doing good!

Hi there! I’d be happy to assist with your Power BI requirement. To display data for both the selected year and the previous year on a drillthrough page, here’s what you need to do:

Step 1: Set Up a Drillthrough Page

Create a new page in your Power BI report and configure it as a drillthrough page.

Add the visuals you want for detailed data analysis.

Step 2: Add a Year Slicer

Insert a slicer for the Year column on the drillthrough page so that users can filter data by year.

Step 3: Create a Measure for the Previous Year

Define a DAX measure to calculate the previous year dynamically based on the selected year:

PreviousYear = SELECTEDVALUE('YourTable'[Year]) - 1

Step 4: Configure Drillthrough Filters

Drag the Year column to the Drillthrough Filters pane.

Add the PreviousYear measure to the Drillthrough Filters pane to ensure the page displays data for both years.

Step 5: Apply Conditional Logic

Use a DAX formula to create a calculated column that identifies the selected year and its previous year:

CombinedYears =

VAR SelectedYear = SELECTEDVALUE('YourTable'[Year])

VAR PriorYear = SelectedYear - 1

RETURN

IF('YourTable'[Year] = SelectedYear || 'YourTable'[Year] = PriorYear, 1, 0)

Filter the visuals on the drillthrough page using this new column to limit data to these two years.

Step 6: Enable Drillthrough Navigation

On the main report page, ensure the drillthrough feature is activated for the Year column.

Users can right-click on a slicer or visual and select Drillthrough to navigate to the detailed page, which will display data for the selected year and the previous year.

This approach ensures your drillthrough dynamically adapts to the selected year, showing relevant data without requiring manual updates. If you face any challenges or need more details, don’t hesitate to ask!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for Microsoft Fabric and Power BI updates: https://www.youtube.com/@AnmolPowerBICorner

lavankumar1989a