Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report that has a table that shows open purchase orders. Purchaing manager then has a set of filters that shows problematic line items. I would like to take the list of purchase order numbers on this fitlered table, then filter the table (or a separate table), for all lines not equal to these purchase order numbers. Is this possible to creat a dynamic filter like this?
PS: I can't just reverse the filter criteria. Since if 1 line item has a problem, all line items for that purchase order need to be frozen.
Solved! Go to Solution.
No worries. Just change the Check measure as follows
Based on my understanding, I did the following
1. Created a table of POS - that contains only the PO numbers from the original Data table.
2. Disable any relationship between this and Data table under the modelling ManageRelationship
3. Created a slicer with POS[PO] and not from Data[PO]
4. Created a measure
I inadvertently pressed the post key last time.
Based on my understanding, I did the following
1. Created a table of POS - that contains only the PO numbers from the original Data table.
2. Disable any relationship between this and Data table under the modelling ManageRelationship
3. Created a slicer with POS[PO] and not from Data[PO]
4. Created a measure
What this does is if the PO number is filtered then it sets it as Y else as N.
5. Created table visual with all columns from Data table. In the visual filters added the Check measure built above and in the filtering condition set it to Y.
What this will show is the selected PO with all line items in that PO.
6. Created another table visual with all columns from Data table. In the visual filters added the Check measure built above and in the filtering condition set it to N.
What this will show is the all PO with all line items in those PO other than the selected one.
Sample output
Slicer on the left from POS[PO], The table next to that is as per step 5 . Then the next one as per step 6.
The bottom table is the full list of Data table.
I hope this works for you.
Cheers
CheenuSing
Thanks for this tutorial, opened up some new ideas for me. I was able to make this work, per your instructions. Unfortuanately, I did not clarify that I need to be able to select multiple values on the slicer.
No worries. Just change the Check measure as follows
Hello, can I do this with categorical variables, instead of 102..101 I have Product_1, product_2...
Regards
Hi @CheenuSing,
Thank you, this worked perfectly. Is there a way to auto check all of the items on the slicer?
Thansk,
Mike
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |