Hi there,
I desperately need help. I have multiple tables loaded in data model which are results of power query. I have created one table with mutual column(resource name) to be used as slicer for multiple pivot table which need to be created from loaded tables, I have create connection between resource name column table and all other tables, one to may. Have checked format of this column in all other tables. Created pivot tables from data model and add slicer from that mutual table. Have connected this slicer to all pivot tables, ticked boxes in report connection, but !!!!!!!!!!!
slicer is not impacting any of tables!!!!!!
why!!!!!!!!!
its two days Iam doing this many times google, chat gpt nothing!!!!!!!!
Please help me on that please.
Can you share your file? It's difficult to help based and your description of the problem only.
its making me crazy!!!
Slicer is working in the attached. Not sure of your issue. Inserted slicer based upon Name. Am I missing something?
Not sure either what your intentions are but if you want the slicer to control both pivot table based on the 'Resource', then you must use the 'Resource' field from the (dimension) ResourceList table in both pivot tables.
@riny really? Is that working for both pivot tables, how come? In my computer is not working!!!!!!
what is the problem???