Hello!
I have a Power Pivot in Excel's data model. In the data model, I have a fact table named "range" and several tables named Table2, Table3, etc. The tables (other than my fact table) serve only to preserve a particular sort order when I create slicers off these columns (per Mynda's video). The problem: when I apply a slicer based of columns from these connected tables, my pivot table shows all the rows in my data set but displays 0 values for the data that the slicers should be filtering out. In other words, the data is being filtered out, but the rows are not. How do I fix that?

Here's an example:
In Table2, there is a column for New Price Segment and a column for Sort Order. I mapped New Price Segment in Table2 to New Price Segment in Range. I made a slicer based on New Price Segment in Table2. When I go the tab labeled "Product" and apply the slicer to my pivot table where "product" is in the rows, I'm seeing every product from Range in the rows but data only appears for the items in the selected price segment.

Something to note about my file attached is that the Pivot Table on the tab labeled Price Segment is value filtered by a measure I created called "VisibleCount". This temporarily fixes the issue for this tab because New Price Segment is in the rows field. However, a major problem is getting the value filter to stay permanently while other slicers are applied and cleared--this isn't user friendly for the people I need to share the file with. Another problem is that I can't use this solution for the tab labeled "Product" because the rows come from the fact table. 

Any help would be so deeply appreciated--this is my first project in Power Pivot! Thank you!