Forum Discussion
Data filtering based on the selection from a different table
Hi all, I would like some help on how to design the following report.
I have the table [VALUES] below
And I want to filter that table based on the table [FILTERS]
In the report I will like to have a dropdown displaying the column "Filter" for the table [FILTERS], when the user select one of the options from 1 to 6 the table value will include and/or exclude the related columns. For Example, If user selects Filter = 1, the table would filter in Option 1 in [VALUES] = A1 and filter out Option 2 in [VALUES] = B2. The below would be the expected output for Filters 1, 2 or 3.
I'm thinking in created a calculated table [FILTERS-MOD] based on [FILTERS] and then just reading the columns for a filter.
Something like:
Then using this [FILTERS-MOD] table to create a [VALUES-MOD] table based on the filters above, but not quite sure how to proceed and even if I am going in the right direction
Any suggestion is more than welcome.
Kind Regards
derekma19 , In case you want use exclude, you need disconnected table
Need of an Independent/disconnected Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE
1 Reply
- amitchandakSuper User
derekma19 , In case you want use exclude, you need disconnected table
Need of an Independent/disconnected Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE