Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Please help display the filtered data.
We have 2 tables:
1. Orders_table: transactions_id (key), client_ID and client_segment
2. Item_table: transactions_id, item_id, item_category, price
One client consists of one segment.
Each client_segment buys items from different categories.
Task: When we filter data by client_ID, display ALL categories that the entire client_segment buys, sort by price.
Solved! Go to Solution.
Hi @irkastar,
Based on my test, we can take the following steps to meet your requirement.
1. Enter the data as your description and create relationship between the two tables.
2. Create slicer and tables to display what we want. Then we can get the result as we need. The table visual is set to sort by price here.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/4uzcyahlfcd0lk0/filter%20for%20advisory%20system.pbix?dl=0
Regards,
Frank
Help please display the filtered data.
We have 2 tables:
1. Orders_table: transactions_id (key), client_ID and client_segment
2. Item_table: transactions_id, item_id, item_category, price
One client consists of one segment.
Each client_segment buys items from different categories.
Task: When we filter data by client_ID, display ALL categories that the entire client_segment buys, sort by price.
Hi @irkastar,
Based on my test, we can take the following steps to meet your requirement.
1. Enter the data as your description and create relationship between the two tables.
2. Create slicer and tables to display what we want. Then we can get the result as we need. The table visual is set to sort by price here.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/4uzcyahlfcd0lk0/filter%20for%20advisory%20system.pbix?dl=0
Regards,
Frank
Hi @irkastar,
Does that make sense? If so, kindly mark my answer as a solution to close the case please.
Regards,
Frank
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |