Conditional Summarize Table

[ak77]

Hi All, 

need a help. 

i have 2 summarize table summarizeTable-1 and summarizeTable-2 with similar columns

i want to display summarizeTable-1 or summarizeTable-2 based on slicer selection.

if Type = "Type1",summarizeTable-1 else summarizeTable-2

Is this kind of implementation possible? Please help

[MNedix · Accepted solution]

Heya,

One way to do it would be to put the tables on top of eachother and then via bookmarks to activate/deactivate the desired table.

[ak77]

Hi ..Thanks Much.. i am not able to get this line ' then via bookmarks to activate/deactivate the desired table.' . is it possible to share a sample pbix .

Sorry for this ask.. I am new to BI..

[MNedix · Accepted solution]

It's a bit long to explain in words so I'm going to let one of my favorite PowerBI Youtube'er to explain - what you're interested in starts at 4:24 - Link

I've also attached a demo file where you can see this in action. Don't forget to use Ctrl + click to activate the button.

[MNedix · Accepted solution]

Heya,

One way to do it would be to put the tables on top of eachother and then via bookmarks to activate/deactivate the desired table.