Dax Query to Map URL to Test field

Anonymous 

To achieve this scenario, you can use the "Drillthrough" feature in Power BI. Here's a step-by-step guide:

1. **Create a separate table**: First, create a separate table that contains the Case No. and corresponding URL.

2. **Define relationship**: Ensure there's a relationship between this new table and your existing data table, using the "Case No." column as the linking field.

3. **Configure Drillthrough**: In the Power BI report view, select the matrix visual. Go to the "Format" pane, and under the "Drillthrough" section, enable the "Drillthrough" option.

4. **Define Drillthrough page**: Create a new page in your Power BI report. Add a table or any other visual where you want to display the details corresponding to the Case No. This page will be your Drillthrough page.

5. **Add URL navigation**: In the Drillthrough page, add a "Web URL" button or shape. In the properties of this button or shape, set the URL to be the corresponding URL from your new table, based on the selected Case No.

6. **Configure Drillthrough action**: Go back to the main page with the matrix visual. Right-click on the "Case No." field in the matrix, then select "Drillthrough" > "New Drillthrough". Choose the Drillthrough page you created in step 4.

Now, whenever you click on a Case No. in the matrix visual, it will navigate to the Drillthrough page, where you can click on the Web URL button to open the corresponding URL.

This approach allows you to keep the URL separate from the matrix visual and provides a clean solution for opening URLs based on the selected Case No.

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