Forum Discussion
Alternative to field parameter for dynamic visualization of multiple metrics at a drop down slicer
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.
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=vlnx7QUVYMEcalculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
1 Reply
- amitchandak
Super User
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=vlnx7QUVYMEcalculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/