Forum Discussion
Show table only when value is selected
Hi Everyone,
I'm looking to make a table show only data when a value is highlighted from another table. By default I only want to show a single table which when selecting a single ID, shows the historic details of that ID in a table:
Not highlighted vs highligthed
I want the bottom table in the left to not show any data when nothing is highlighted.
Any help would be greatly appreciated!
5 Replies
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
Try to use
IF ( ISFILTERED( FACT[ID] ) ,1,0)It worked for me.
Please go through this blog, you will understand clearly.
