Here is a best practice to improve your dashboard usability. If you have an interactive dashboard, highlight user selections thru conditional formatting.
Check out below quick video to understand what this means.
You may watch this video on our YouTube channel too.
Download Example workbook
Please click here to download the example workbook for this video. Play with conditional formatting rules to learn more.
More ways to create awesome dashboards
- Never use simple numbers in your dashboards
- Place all vital information in golden triangles
- Show alerts & warning icons in dashboards with conditional formatting
- Create duplicate controls to improve usability of dashboards
- Add text narrative to your dashboards – case study
- Use shapes to enhance dashboards & charts
- Process & explanation – how to create awesome dashboards – podcast
3 Responses to “Filter one table if the value is in another table (Formula Trick)”
What about the opposite? I want a list of products without sales or customers with no orders. So I would exclude the ones that are on the other table.
Good question. You can check for the =0 as countifs result. for example,
=FILTER(orders, COUNTIFS(products, orders[Product])=0)
should work in this case.
PS: I have added this example to the article now.
Hi there!
Could i check if there was a way to return certain fields of the table only?
so based off your example above, i would like to continue to use the 'Products" table as a way to filter out items from my "Orders" table, but only want to show maybe only the "Product" and "Order Value" fields, rather than all 5 fields (sales person, customer, product, date, order value).