Forum Discussion
Table Vision Formatting
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
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
2 Replies
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
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.
