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

[Anonymous]

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 allow a user to use a table visual or a matrix to display a custom cross-section of different segments, without the use of a unique record identifier.  For example the whole cross-section would look like this:

But I would need the slicer to dynamically change what the user sees; e.g. if the user only chooses "Merchant" then I only want to see the following:

So I'm less interested in a specific solution to my problem, more just wondering if what I'm attempting to do is even possible, and also if it is possible to do without unpivoting my data.  My actual data file has nearly 10 million records and about 9 different categories so I am not looking to impede performance.

Thank you for any help

[v-kelly-msft]

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 · Accepted solution]

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]

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!

[amitchandak]

@Anonymous , You can replace measure values. Or you can make it blank. Using the meausre slicer.

measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

// With external tools you have some more flexibility
https://www.youtube.com/watch?v=vlnx7QUVYME

But to hide show, you need bookmarks

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive