Forum Discussion

ak77's avatar
ak77
Post Patron
1 year 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.

 

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

 

Is this kind of implementation possible? Please help

 

 

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

3 Replies

  • MNedix's avatar
    MNedix
    Solution Sage
    1 year 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.

  • ak77's avatar
    ak77
    Post Patron
    1 year 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
      Solution Sage
      1 year 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.