Forum Discussion
Clickable table/Matrix value to redirect on another report same as of Drill through functionality.
I'm reaching out to seek your expertise and guidance on implementing a specific functionality within Power BI that resembles the drill-through feature.
Currently, I'm working on a project where I need to create a clickable matrix or table within a Power BI report. The objective is to enable users to click on a value in the matrix or table, which would then redirect them to another report with detailed information related to the selected value.
To provide a bit more context, I'm essentially looking to replicate the drill-through functionality but within a matrix or table visualization, where clicking on a specific cell or value will dynamically redirect users to another report page containing relevant details.
I've explored various options within Power BI, but I haven't been able to find a straightforward solution to achieve this functionality. Hence, I'm reaching out to the community to seek advice, best practices, or any insights on how to implement this feature effectively.
If anyone has experience implementing similar functionality or knows of any resources, tutorials, or Power BI features that could help achieve this goal, I would greatly appreciate your input and guidance.
Thank you in advance for your support and assistance. Your expertise will undoubtedly contribute to the success of this project and help enhance the overall user experience within our Power BI reports.
5 Replies
Hello there,
To navigate between reports, you must first ensure that you have the correct relations between the data in your destination and origin report, once you have ensured that the relations are done correctly in the model view then you may use this dax meassure: ReportNav = SELECTEDVALUE(YourTable[YourField])
If that is not enough you may try: Dettail = CALCULATE(SUM(FactTable[Value]), FactTable[Dimension] = SELECTEDVALUE(DrillThroughTable[Dimension]))
Hi AnassEss, let me explain you more on statement-
i have 1st table as Customer having column name "HCP Name", based on this column i want to switch to another report name HCP where HCP report will show all the related details on clicked HCP Name from Customer table.
Q1, where i can create this measeure, on which table.
Q2, how this measeure will be usedThanks for clarifying:
Q1. Creating the Measure:
- You can create this measure in the Customer table or in a separate table that contains information about the HCPs (Healthcare Professionals).
- You can also create the measure by clicking the "Modeling" button in the superior part of the power bi desktop dashboard and then you just select "New meassure" (this is if you don't know how to create a meassure)
- If you create it in the Customer table, you will use a DAX measure to capture the selected HCP name.
Q2. Using the Measure:
- Once the measure is created, you will use it in an action within Power BI to enable users to navigate to the HCP report.
- To do this, go to the "Modeling" tab, select "New Table", and create a new table with a single column containing the unique values of "HCP Name" from the Customer table.
- Then, create a relationship between the "HCP Name" column in the Customer table and the new table you created.
- After creating the relationship, go to the "Format" pane of the table visual containing the "HCP Name" column in the Customer report.
- Under "Data category", select "Web URL" and enter the URL of the HCP report, including a placeholder for the selected HCP name
I hope it helps you this time 🙂
