Table Vision Formatting

[erhan_79]

Hi there ;

İ would like to get your information about below issue if it possible or not , 

imagine that i have a table as below which shows order summary list 

for example is there any possibility that i will click on "4500" amount and system will open below order detail table vision via a bookmark that i created ?

I know that if that two vision is related with relationships when i click on "4500" amount other visiual will show related infos with this order but , i would like work the action that like when i click on "4500" another will page will be open , like screen will go to another bookmark page , i hope it is clear , thanks in advance 

[v-alq-msft]

Hi, @erhan_79 

Based on your description, you may try using drillthrough to achieve your requirement.  There is a relationship between two tables based on 'Order No'. The pbix file is attached in the end.

Report Page 1:

Report Page2('Order No' is set as drillthrough field):

Finally you can drill though data point '4500' on 'Page 1' to get the corresponding result on 'Page 2'.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@erhan_79 , Either order summry should be a master table or you should common dimesnion for order no, order date . They use drill through

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