Forum Discussion

ADP007's avatar
ADP007
Helper IV
4 years ago
Solved

MAtrix Filtering a Scatter

Hi all,   In my dashboard I have a table visual with some items. When I click on a row of the table it filters a scatter visual. This is exactly what I need but how can I show no values in the scat...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    ADP007 , Create a card visual on top of scatter visual and use conditional formatting for both background color and font

     

    if(isfiltered(Table[Column]), "FFFFFF00", "FFFFFF")

     

    In conditional formatting use field value option and use above measure

amitchandak's avatar
amitchandak
Super User
4 years ago

ADP007 , Create a card visual on top of scatter visual and use conditional formatting for both background color and font

 

if(isfiltered(Table[Column]), "FFFFFF00", "FFFFFF")

 

In conditional formatting use field value option and use above measure

  • ADP007's avatar
    ADP007
    Helper IV
    4 years ago

    Hi amitchandak, thanks for your reply. I"ll accept it as a solution but I adapted it a bit.

     

    Check Filtered = IF(ISFILTERED('table'[KPI]), "Y", "N")
     
    Then I used the measure in the visual filter option "Check Filtered = Y"
     
    Cheers