Forum Discussion
highlight data in a table visual based on another table selection
Hi,
I have two table visual on two different view. When SupplierA selected from table1 then SupplierA in table 2 should be highlighted. there is no join in the data model between the views.
Any pointer will be helpful
thanks,
Viji
Hi,
I found the way to highlight the table
step 1 - created measure
flag2 = IF(CONTAINS(Fin,Fin[SupplierName],if([Selected GSN] = "","invalid",[Selected GSN])),1,0)
----- there was few blank SupplierName in tableB so to avoid highlighting added "invalid" code
Step2 - Conditional formatting on measure values based on flag2
and set highest value to 1, did the magic
Since it is matrix visual, highlighted measure values with conditional formatting. Looking for a way to highlight dimension column.
thanks,
Viji
3 Replies
viji_rajaraman , Table to table interaction is filter, not highlight. So I doubt that
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Hi,
yes, interaction enabled in visual filter and able to see the Supplier column name from the tableA in tableB filter list, even the selected data is shown .
But it is not filtering tableB data. there is no relationship between tableA and Table B is that the reason it not filtering. SupplierName column is there in both the tables.
Thanks,
Viji
Hi,
I found the way to highlight the table
step 1 - created measure
flag2 = IF(CONTAINS(Fin,Fin[SupplierName],if([Selected GSN] = "","invalid",[Selected GSN])),1,0)
----- there was few blank SupplierName in tableB so to avoid highlighting added "invalid" code
Step2 - Conditional formatting on measure values based on flag2
and set highest value to 1, did the magic
Since it is matrix visual, highlighted measure values with conditional formatting. Looking for a way to highlight dimension column.
thanks,
Viji
