I have a data table which contains documents which have been analyzed prior in a database. The result of this analysis is documented in seperate columns Check1, Check2 etc. depeding on the typ of the analysis.
The table is fully loaded in the Power BI report.
Now want to add an interactive element that allows the user to filter the table (and the visuals in the report) dynamically by selecting Check1 = Y or Check2 = Y
| Doc--- | Amount--- | Check1--- | Check2--- | Check3--- | Check4--- |
| 1 | 400 | Y | | Y | |
| 2 | 200 | Y | Y | | Y |
| 3 | 500 | | | Y | Y |
| 4 | 600 | | Y | | Y |
I want to enable the user now with a button or a dropdown filter to apply those SELECT queries automatically in a non technical fashion.
The effect of the query should reduce the number of rows shown in the table like a SQL select query with a where condition.
e. g.
SELECT * FROM TABLE WHERE CHECK1 = 'Y'
SELECT * FROM TABLE WHERE CHECK2 = 'Y'
SELECT * FROM TABLE WHERE CHECK3 = 'Y'
First idea:
Simplest solution I can think of is a simple button (one button per check) where the selection of the button applies this condition.
Second idea: Not wanting to add a button per CHECK
I would like to create these queries as filter conditions and add them to a dropdown list. Where selecting a value from the dropdown list applies this query to the table.
The visual function is only to apply or not apply this filter condition on the table.
This interactive element /value does not need to show values, we will just give him a label that says CHECK1=Y .
Thank you for any support.
