Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Proud to be a Datanaut!
@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
Hi @amitchandak, thanks for your reply. I"ll accept it as a solution but I adapted it a bit.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |