Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need help in displaying table based on row selected in another table. Please find details about my requirement.
I have a database table having 20+ columns, some key columns are "Order Details" "Schedule Status" and "Finance Status"
I created a table visual (TV-1) which shows only 3 columns "Order Details" "Schedule Status" and "Finance Status".
When use select a specific "Order Detail" in the Table Visual (TV-1) I want to show all the details from 20+ columns for the selected "Order Detail" in another Table Visual (TV-2)
I also want to disable the Table Visual (TV-2) when no row is selected in TV-1.
How can I link Table Visual (TV-1) and Table Visual (2)
You cannot do that with a single table. Either create a shadow copy of the table (ie duplicate the query) or normalize your data into a proper data model.
User | Count |
---|---|
16 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
1 |