Forum Discussion

ak77's avatar
ak77
Icon for Post Patron rankPost Patron
2 years ago
Solved

Conditional Summarize Table

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. ...
Need Help
Show and Tell
Tips and Tricks
  • MNedix's avatar
    MNedix
    2 years ago

    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.

  • MNedix's avatar
    MNedix
    2 years ago

    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.

ak77's avatar
ak77
Icon for Post Patron rankPost Patron
2 years ago

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's avatar
    MNedix
    Icon for Solution Sage rankSolution Sage
    2 years ago

    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.