Forum Discussion
Solved
Dynamic Field Parameter Not Working
Hello, I am somewhat new to Power BI and these forums, but I'll try to convey my issue the best I can. My goal is to have a dynamic graph for the Y value of each different Supplier Product Si...
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
Okay I might be really picking your brain here, but from these changes are you able to change the color of the column based on whether it exceeded the target or not (Like red for under and green for over)? Even after filtering with new target lines?
Hello, Sorry for the late response.
You can use the following DAX:
And then create a conditional formatting for the columns:
gadielsolis You're incredible! I got mine up and running the way I want it, thank you.