Forum Discussion
Creating new row or table based on slicer selection
I am not sure this is possible to do but wanted to run it by the community.
I have one table with vendors, contact email, and contact phone. The second table is a list of facilities and up to 4 different vendors that location could use.
I am trying to if i use a slicer to select that one facility add the vendor contact information below that location but if all locations are selected do not have any of the vendor information.
Hi Anonymous ,
According to your description, in powerbi, the filter is used to filter conditions, and the value displayed in the table is the result of all rows that meet the condition. You cannot dynamically increase or decrease column values through the slicer.
Similar results can only be achieved in the following way:
List of ID = CONCATENATEX ( VALUES ( 'Table (3)'[Vendor]), 'Table (3)'[Vendor], "," )
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous , You can not edit data on power bi.
You need to integrate with power app
Hi Anonymous ,
According to your description, in powerbi, the filter is used to filter conditions, and the value displayed in the table is the result of all rows that meet the condition. You cannot dynamically increase or decrease column values through the slicer.
Similar results can only be achieved in the following way:
List of ID = CONCATENATEX ( VALUES ( 'Table (3)'[Vendor]), 'Table (3)'[Vendor], "," )
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
