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

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