Forum Discussion
Clickable table/Matrix value to redirect on another report same as of Drill through functionality.
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 used
Thanks 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 🙂
Can you share the working PBix file for this. it seems confusing for me. as how measure can be used in action ?
I don't have a pbix file with this (The only pbix files i got are confidential) but I can provide some screenshots if that helps you understand the meassures and how to use them:
1. Creation:
In the superior part of the pbix desktop file you find this:
You click there and then here:
2. Afterwards you get a space where you can write the dax meassure and after writing it:
You put it in a column or table as follows: Select the table or column and then select the meassure that you have just created to apply it to the table or column by checking the box of the meassure:
I hope this helps