How do I create a table to store values I filter down to in my report.

[Anonymous]

Hi There,

I am currently trying to imploment a functionality in my report, but require assistance in deciding if it is possible or not. I have a page in my report where I can filter down in a multitude of different ways. I want a way to be able to filter down, store the results of the filter, and have the ability to do this multiple times.

At the end, I should have a table or list, or something that has a list of all of my filtered down results that I got beforehand.

Kind Regards

[v-juanli-msft]

Hi @Anonymous 

physics table doesn't support to store the result when you filter the data.

But you could create a measure(Modeling->New measure), then add this measure in a table visual.

PattemManohar's suggestion may be helpful.

Best Regards

Maggie

[PattemManohar]

@Anonymous  Hope you are looking for this..

Create a New Measure as below

Test174 = CONCATENATEX(VALUES(Test174VarbySelection[Customer]),Test174VarbySelection[Customer],",")

[Anonymous]

Hi @PattemManohar 

Thank you for your reply!

While this remains useful, it doesn't quite capture my needs.

Rather than just storing what my filters are currently set to, I would like it to store everything I have filtered down to.

So for example if I filtered down to customer A using the slicer, it would add that to the table, then I would  deselect customer A and it would store that. Then I select another customer and it adds that to the table.

So its more storing my historical filter results?

[PattemManohar]

@Anonymous I don't think you can achieve such output in Power BI.