MAtrix Filtering a Scatter

[ADP007]

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.

[BA_Pete]

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

[ADP007]

Thanks @BA_Pete I used part of @amitchandak solution.

[amitchandak · Accepted solution]

@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]

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