Forum Discussion
Row level analitcs in Matrix table
Dear All,
I am new user, and need advice/help with the following issue. I created a matrix table with different DAX metrics from dataset which works on table import and is refresed from SQL server. Please see the screenshot below. The dataset has more then 70 fields and is transaction based 1 row 1 transaction. Now I would like accomplish to show all transactions which belongs to certain rule_name_string --> let's say when users click on each rule_name_string that new table/view opens and shows row based table with all fields from the dataset. I am not sure how to accomplish this, is this hierarchy, chiled-parent or something else?
Thank you for all tips.
Kind regards
iigorilic , You can create a drill through page or tooltip page
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
2 Replies
iigorilic , You can create a drill through page or tooltip page
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
amitchandak drill through page solved my issue. Thanks a lot for this input.
Best regards 🙂
