Dynamically change the KPI in table Visual

You can use bookmarks to dynamically switch between different table visuals based on slicer selection. First, create two separate table visuals: one containing SalesOrderID, Sales, and Qty for North America, and another containing SalesOrderID and Profit for other regions. Place both tables on top of each other so they appear in the same position. Next, add a slicer with the Region field from the Region Table and enable single selection. Then, create bookmarks by first selecting "North America" in the slicer, hiding Table 2, and adding a bookmark named "North America View." Similarly, select a different region, hide Table 1, show Table 2, and create another bookmark named "Other Regions View." Finally, insert two buttons, set their actions to trigger the corresponding bookmarks, and enable "Action" on each button in the Format pane. This setup ensures that when North America is selected, the table displaying Sales and Qty is shown, and when another region is selected, the table displaying Profit is shown, all without requiring any DAX. Let me know if you’d like to explore automating bookmarks using a selection pane trick.