Alternative to field parameter for dynamic visualization of multiple metrics at a drop down slicer

[Anonymous]

We all know that the field parameter is a great solution for dynamic visual but unfortunatly this feature is not avalable while using live connection.

What is the alternative DAX solution to create the field parameter at the PowerBI that mimcs the same ?

Please provide if there is any example for visulizing multiple trends on a line chart using a dropdown filter not using the field parameter.

Example : showing the sale,profit,weight at moth,day,weekly trends X: Time Y: Metrics and two dynamic slicers as time and Metric

Thank you.

[amitchandak · Accepted solution]

@Anonymous , You can try calculation groups

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Other alternatives

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYME

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/