Help - Using a Slicer to Change Column Value

---

Anonymous wrote:

Hi ChrisDC83,

If there is no relationship between Selection_Table and fact table, Power BI Desktop doesn’t know choose which of the two values in the Selection_Table[Selection]  field to use. You can wrap Selection_Table[Selection] in a FIRSTNONBLANK() function to solve this issue. 

There is a similar blog for your reference.
http://breaking-bi.blogspot.sg/2016/06/power-bipowerpivot-using-slicers-to.html

If the above issue still persists, please post sample data of your tables.

Thanks,
Lydia Zhang

---

I use that approach you linked to in the blog frequently for measures, but for a column it doesn't seem to work as easily.

Essentially my table looks like this:

Fact:

Month | Product Line | Product | Sales Volume | Sales $ | Profit

So what I'm trying to do is get a variable that swaps between Product Line and Product depending on what the user wants to see.