How to dynamically choose which rows to include in 2nd report, based on user input from 1st report

[Anonymous]

Hi All, I have a first page of a report which is just a matrix visual, structured as follows:

ProductID	Measure1	Measure2	...
1	...	...	...
2	...	...	...

The user of the report will be reviewing the products and determining, based on their product knowledge and the values of the associated measures for those products, whether they would like to include that particular product in a secondary report on another page. 

I considered adding a true/false calculated column, but would need the user to be able to dynamically toggle a true/false value for a certain product based on their desire to include/exclude. I could then only use products in this secondary report when the value is toggled to true.

Does anyone have an idea of how I could accomplish this?

Thanks a bunch.

[v-luwang-msft]

Hi @Anonymous  ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[amitchandak]

@Anonymous , If you want to do multi-select and drill through that is not possible as of now.

[Anonymous]

Hi @amitchandak , I know there's no easy way to do it, but would it be possible to accept user input to modify a table in Power BI, so that I end up with a table like the following

ProductID        Toggle

1                      True

2                      False

Then I can use this table to filter which products are included in the second page of the report.

Thanks,

Kalie

[amitchandak]

@Anonymous , we should create a measure with user input and use that as a visual level filter. or we can do binning. 

The measure used at the line level can work as a column. 

Assume if product is lowest level in the display, the measure will work on that. And I use that a filter at that level .

Select multiple with the Ctrl key pressed. Right-click include and then try