Forum Discussion
Help - Using a Slicer to Change Column Value
I have a need to change what column is shown on charts basis a slicer. In my data set I have Product Line and Product Name (multiple product names roll up to a single product line) and the users wan...
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