Forum Discussion
Show table only when value is selected
To show the bottom table only when a value is selected in the top table, you can use the "Visual Level Filters" feature in Power BI. Here are the steps:
Select the bottom table in the left.
In the "Visualizations" pane, select the "Visual level filters" option (it looks like a funnel icon).
In the "Filters" pane that appears, click the "Add filter" button.
In the "Add filter" dialog box, select the column that corresponds to the ID in the top table.
Select the "Basic filtering" option.
Select the "is not blank" option.
Click "OK" to close the dialog box and apply the filter.
Now the bottom table will only show data when a value is selected in the top table. When no value is selected, the bottom table will be empty.
Hi Slayer,
The ID's are the same field so the Is not Blank does not work for me. I've been able to solve the issue myself though:
Highlight check =
IF ( SELECTEDVALUE ( FACT[ID] ) = ALLSELECTED ( FACT[ID] ), 1, 0 )
The logic applies as follows:
I'm using an IF statement to check the selected value from the Top table against the ID's being shown in the bottom table (ALLSELECTED). If true then 1 else 0.
I then filter the table based on the measure and say that the measure has to equal 1.The only problem I have right now is that the IF statement returns an error when there is no value selected. That part still needs solving
