New Power BI User

[bwlytkr]

I am new to the power bi community, and I can use some help. I created this simple pivot table, and I am not able to copy and paste it like I normally would in excel when I created one and wanted to copy and paste so I could create another pivot with the same info but, just need to filter on different items for a different view. Is this something I no longer can do in Power BI? If I do this in Power BI the old and new table change when I change filters and if i click on a cell in the new table it changes the old table. Any thoughts on how I can copy the old table to I don't have to create new ones that have the same data and format to them?

 

[Matt Allington]

Do you mean power pivot for Excel? Yes, you can copy and paste pivot tables. If you have slicers connect, they will probably be connected to both copies meaning changes in one will be inherited in the second. You can change this from the slicer menu. There are also some settings controlling how pivots are linked. I’m not sure where; just look at the report menus.

 

[bwlytkr]

Do you mean power pivot for Excel? Yes, you can copy and paste pivot tables. If you have slicers connect, e it a they will probably be connected to both copies meaning changes in one will be inherited in the second. You can change this from the slicer menu. There are also some settings controlling how pivots are linked. I’m not sure where; just look at the report menus.

thanks for the help. I'll give it a try

 

[Rohan22]

I am new to the power bi community, and I can use some help. I created this simple pivot table, and I am not able to copy and paste it like I normally would in excel when I created one and wanted to copy and paste so I could create another pivot with the same info but, just need to filter on different items for a different view. Is this something I no longer can do in Power BI? If I do this in Power BI the old and new table change when I change filters and if i click on a cell in the new table it changes the old table. Any thoughts on how I can copy the old table to I don't have to create new ones that have the same data and format to them?

Looks like you want to 'Edit Interactions' in visuals. If so, then go to the 'Report View' and then select particular Slicer/visual and then in Ribbon go to "Format" tab where you will see 'Edit interactions' and then you can only select that Pivot which you want to change with Slicer and for the other one you can click on icon which I highlighted in attached image so that it will not interact.