Forum Discussion
cgpahnk
2 years agoFrequent Visitor
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...
- 2 years ago
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
2 years agoResolver III
Hello, Sorry for the late response.
You can use the following DAX:
And then create a conditional formatting for the columns:
cgpahnk
2 years agoFrequent Visitor
gadielsolis You're incredible! I got mine up and running the way I want it, thank you.