Forum Discussion
Dynamic Field Parameter Not Working
Hello cgpahnk ,
My advice would be using unpivot in power query to get the data in the following format:
Once you have the data like that you can insert a slicer referencing the field "Product" so you can filter the product you want to see in the graph
gadielsolis much appreciated! I think this will work. Only issue I have now is ordering the graph by date but I can probably create a date table for that.
Do you think I'd be able to have a dynamic target line that changes for each filter selection?
My advice would be create a separate table with the products and the target for each product (you can create it in excel or within power BI), after that you can connect both tables using the product field and add the target as a line in the grap). Find below some screenshots for reference
Important: In the slicer you must use the product field coming from the targets table since this will be your key value.