Forum Discussion
Dynamically change the KPI in table Visual
Hi,
I am trying to change the existing column header and its value in a table visual according to what is selected in the slicer.
Example :
If Slicer Region ="North America" then In table we should get SalesOrderID, Sales and Qty column
Else
If Slicer Region <> "North America" then in table we should get SalesOderID, Profit only
How can this be achieved?
Thanks for your reply PijushRoy ,
I used a shape to dynamically update the table header and applied DAX to modify the measure values.
However, I have to keep the columns static and cannot dynamically remove them based on slicer selection.
4 Replies
- PijushRoyCommunity Champion
Hi AnkitaaMishra
Can you please share sample data in usable format excel
or sample PBIX file with similar data model you have?- AnkitaaMishraSuper User
Thanks for your reply PijushRoy ,
I used a shape to dynamically update the table header and applied DAX to modify the measure values.
However, I have to keep the columns static and cannot dynamically remove them based on slicer selection.
- AnonymousNot applicable
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.
- AnkitaaMishraSuper User
Thanks for your reply Anonymous , but cannot use bookmark option for this scenario.