Dynamic Category Using a Slicer

Most of the time, I post on the community to ask for help but this time I am giving back.

I've read several posts that dynamic category based on slicer selection is not possible. While it may not be an out of the box feature, it is possible with some tweaking. I've also read similar solutions but I find mine simpler and easier to follow :). The trick makes use of the following:

• adding an index column
• referencing a query
• unpivoting columns 
• relationship

In my sample pbix (click to download from my GDrive), I connected  to the Ofeed data from powerbi.tips (click for the link to the webpage)

http://services.odata.org/AdventureWorksV3/AdventureWorks.svc

 and used CompanySales table. 

Here are the steps,

1. After successfully connecting to CompanySales table, add an index column to it and just name it "Index". (We'll be using index number as unique identifier in a relationship.)
2. Change Index data type to whole number. 
3. Create another query referencing CompanySales table and name it "Category".
4.  Remove all columns except ProductCategory, ProductSubCategory, OrderYear, OrderQtr and Index.
5. Right-click Index column and Unpivot Other Columns.
6. Rename these newly created columns: Attribute to Category, and  Value to Subcategory.
7. Change data type of Category and Subcategory columns to text.
8. Load the query.
9. Create a relationship betwen CompanySales[Index] and Category[Index] (i set mine to both direction)
10. Add Category column to a slicer visual (turn on Single Selection and off  Select All) 

You may view my sample report here:

https://app.powerbi.com/view?r=eyJrIjoiMjJmODEyNWYtNDk5OC00NjU1LTkzMjQtYzQ4YTQzNjA2MjgwIiwidCI6IjZjNTNiN2YxLWNlNjAtNDI1Mi05YmI2LTJkYmEzMWM0NjVjMSIsImMiOjEwfQ%3D%3D

Please don't forget to kudos this post if you find this helpful.