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 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.
Solved! Go to Solution.
Hi @ghe7549 ,
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.
Hi @ghe7549 ,
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.
@ghe7549 , You can not edit data on power bi.
You need to integrate with power app
refer - https://www.youtube.com/watch?v=LxuRzj0X348
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |