Forum Discussion
Solved
Using Field Parameters efficiently with Small Multiples
Hi Power BI Community! I am in need of some help optimizing the efficiency of a slicer forged from a field parameter to control the metrics within my comparative area chart which uses small multiple...
Thanks johnt75 for the proposed solution.
I ended up copying the dataset and pivoting the Enrollment, Staff, and Diplomas columns. This allowed me to make a slicer based off a new column called "Metric" instead of having a slicer based off a field parameter. From there, I could now make a new measure for Lakeview based off the selected value the user had chosen in the slicer by utlizing the SWITCH function in DAX.
paige_kinney Did this answer your question? If so please click [accept solution] and thank the helper or give feedback. Thank you.