Forum Discussion
Filtrar y traer otros
buenas. tengo una tabla origen de compras con las columnas: fecha, proveedor,ramo, cantidad y valor
Tengo un slicer con el filtro por proveedor
He creado 2 tablas visuales, en una preciso que me traiga los datos del proveedor seleccionado
En la otra tabla necesito que me traiga todos los proveedores menos el que seleccione en el filtro
Como lo puedo hacer?
Hi YOSIEMPREYO12 ,
To meet your requirement of displaying data for the selected supplier in one visual and all other suppliers in a second visual, follow these steps:
Create a disconnected slicer table named Supplier_Disconnected using the following DAX formula:
Supplier_Disconnected = VALUES('table'[Supplier Name])Use Supplier_Disconnected[Supplier Name] in your slicer visual.
Create a DAX measure named EXCLUDE as follows:EXCLUDE = SWITCH(TRUE(),
ISFILTERED(Supplier_Disconnected[Supplier Name]) &&
VALUES('table'[Supplier Name]) IN VALUES(Supplier_Disconnected[Supplier Name]), 0,1)Apply the EXCLUDE measure as a visual-level filter:
For the first table visual (to show all suppliers except the selected one), set the filter to EXCLUDE = 1.
For the second table visual (to show only the selected supplier), set the filter to EXCLUDE = 0.Please look into the PBIX file for your reference.
Best Regards,
Chaithra.
5 Replies
v-echaithraCommunity Support
Hi YOSIEMPREYO12 ,
To meet your requirement of displaying data for the selected supplier in one visual and all other suppliers in a second visual, follow these steps:
Create a disconnected slicer table named Supplier_Disconnected using the following DAX formula:
Supplier_Disconnected = VALUES('table'[Supplier Name])Use Supplier_Disconnected[Supplier Name] in your slicer visual.
Create a DAX measure named EXCLUDE as follows:EXCLUDE = SWITCH(TRUE(),
ISFILTERED(Supplier_Disconnected[Supplier Name]) &&
VALUES('table'[Supplier Name]) IN VALUES(Supplier_Disconnected[Supplier Name]), 0,1)Apply the EXCLUDE measure as a visual-level filter:
For the first table visual (to show all suppliers except the selected one), set the filter to EXCLUDE = 1.
For the second table visual (to show only the selected supplier), set the filter to EXCLUDE = 0.Please look into the PBIX file for your reference.
Best Regards,
Chaithra. - Rupak_bi
Super User
Hi YOSIEMPREYO12 ,
The first visual will work straight based on the slicer.
for second one use a measure to populate the data.
Measure = calculate(sum(Margen Pond),all(table,proveedor),table[proveedor]<>selectedvalue(table[proveedor]))
- v-echaithra
Hi YOSIEMPREYO12 ,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E. - v-echaithra
Hi YOSIEMPREYO12 ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Chaithra. - v-echaithra
Hi YOSIEMPREYO12 ,
We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.
