Forum Discussion

viji_rajaraman's avatar
viji_rajaraman
Frequent Visitor
4 years ago
Solved

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.    ...
Need Help
  • viji_rajaraman's avatar
    viji_rajaraman
    4 years ago

    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

viji_rajaraman's avatar
viji_rajaraman
Frequent Visitor
4 years ago

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

 

  • viji_rajaraman's avatar
    viji_rajaraman
    Frequent Visitor
    4 years ago

    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