Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Table visual - Is it possible to dynamically add/remove columns?

I have seen a lot of tutorials on how to dynamically change column selection in table visuals and matrices but none of them have quite fit my use case.  Basically, I'm wondering if it is possible to ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    While this is somewhat along the lines of what I am looking for, I do need the ability to see more than the MAX() value which would mean that the table expands horizontally and vertically when more categories are added, and contracts when they are removed.  There appears to be no native functionality in PowerBI to allow what I am looking for, so I am going to have to use bookmarks to achieve it.  Thank you though.

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi Anonymous ,

 

First create a slicer table as below:

 

Then create a measure as below:

Measure = SWITCH(
    SELECTEDVALUE('Slicer table'[Slicers]),
    "Merchant",MAX('Table'[Merchant]),
    "Product",MAX('Table'[Product]),BLANK())

And you will see:

I also added another option of unpivoting the table to realize it in my sample .pbix file,you could turn to it to check which one is better.Pls check attachment for details.

 

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

While this is somewhat along the lines of what I am looking for, I do need the ability to see more than the MAX() value which would mean that the table expands horizontally and vertically when more categories are added, and contracts when they are removed.  There appears to be no native functionality in PowerBI to allow what I am looking for, so I am going to have to use bookmarks to achieve it.  Thank you though.

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Sorry for not being able to help on this issue,since you have a good idea of using bookmarks to address it,could you pls mark the reply as answered to let more people find the solution.

    Much appreciated.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!