Forum Discussion
Separate Table visual based on selected value from slicer
Hi,
Is this possible in power bi to show separate table visual for each selected item from slicer.There is requirement from client to show data in seperate table visual for each selected item from slicer as shown below.Can any one help me on this.
It's an odd BI requirement. How would that work with 5 selections? 10? 100?
My suggestion is offering a summary table where each row is a different msdyn_name.
Then, you can create a drillthrough table with msdyn_name as the drillthrough value, which will be the detailed table.
If your client doesn't want to right-click for the drillthrough, you can add a button with drillthrough functionallity after you create the drillthrough table.
Thanks rbriga ,yes i had in my mind the drill through option.Will discuss it further with client.Thanks Again for suggestion.
2 Replies
It's an odd BI requirement. How would that work with 5 selections? 10? 100?
My suggestion is offering a summary table where each row is a different msdyn_name.
Then, you can create a drillthrough table with msdyn_name as the drillthrough value, which will be the detailed table.
If your client doesn't want to right-click for the drillthrough, you can add a button with drillthrough functionallity after you create the drillthrough table.
Thanks rbriga ,yes i had in my mind the drill through option.Will discuss it further with client.Thanks Again for suggestion.