How to jump to another form when I click on a field

[mecr123]

I am wondering how can I do the following

I am showing customer information in the matrix visual – customer name and invoice value. I have a hierarchy set up so that when I click on a customer their invoice details display in the drill down on the screen. This all works fine.

So what I would like is that when the user clicks on the invoice ID a new form will display. This will be the actual invoice itself.

The questions are

1. Can I display a new form when I click on a field, in my case the invoice ID
2. How would I design(what visuals do I use) to be able to show an invoice form on the screen

[v-danhe-msft · Accepted solution]

Hi @mecr123,

Based on my test, you could achieve the feature by using the “Drill Through” function, you could refer to below steps:

1.I have entered some sample data like the picture below.

2.Create a table visual in Page1 and page2.

3.Switch the Drill Through function on page2 and add the [ID] field.

Now you can right click the ID in Page 1 and drill through to the Page 2 to see the detail sales.

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

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/peqi4xy0oe0nzxc/How%20to%20jump%20to%20another%20form%20when%20I%20click%2...

Regards,

Daniel He