Click here to go to the “AdventureWorks Color Catalog” dashboard
This is a fun project. I built this to show measures containing DAX functions, VALUES(), HASONEVALUE(), and CONCATENEX() which is a pretty fun function! This dashboard might go to a salesperson, or to a warehouse manager to keep track of the different products by color. I also like VALUES() which returns a column table with the unique values in that column and respects the original filter index. In addition to using it to return the colors to work with CONCATENEX(), I used it to return the Category names as values, not only as row headers. Once again, the interaction of the slicers adds quite a bit of granularity to the report.
Nathaniel Cohen 