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 scatter when no item is selected in the table?

 

Thanks

D.

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

4 Replies

  • 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
       

       

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    Hi ADP007 ,

     

    You will need to adjust the measure that displays the values in you scatter chart using either HASONEVALUE or ISFILTERED.

    You would use this with one of the dimensions that categorises the data in your table.

    For example, if your table has sales by country, you might write a measure like this for your scatter chart:

    _scatterSales =
IF(
  HASONEVALUE(countries[country]),
  SUM(sales[sales]),
  BLANK()
)

     

    This should then only display values in your scatter chart if one row in the table was selected.

    If you swap HASONVALUE for ISFILTERED, it would allow you to multi-select country rows and still work, until you has multi-selected all of them and, therefore, that field was no longer filtered.

     

    Pete