Forum Discussion

MiekeV's avatar
MiekeV
Frequent Visitor
6 years ago
Solved

KPI- multiple select slicer

My issue is similar to this one that was posted in 2017: https://community.powerbi.com/t5/Desktop/KPI-Visualization-Problem-With-Multiple-Select/td-p/165189   I am wondering if there is a solution...
Need Help
Tips and Tricks
Tutorial Requests
  • kentyler's avatar
    kentyler
    6 years ago

    Here is a link to the use of Parameter tables https://www.daxpatterns.com/parameter-table/

    which act like slicers but are, i think more open to manipulation in DAX

    Notice that even in this article the selection of multiple parameters is considered to be "bad".

    I suspect your way out might be to make 3 parameter tables, for example, and allow the user to select up to 3 months. Then your DAX code would have to check each parameter and react differently depending on which one was selected.

    This would be pretty advanced, but you could probably do.

kentyler's avatar
kentyler
Solution Sage
6 years ago

Here is a link to the use of Parameter tables https://www.daxpatterns.com/parameter-table/

which act like slicers but are, i think more open to manipulation in DAX

Notice that even in this article the selection of multiple parameters is considered to be "bad".

I suspect your way out might be to make 3 parameter tables, for example, and allow the user to select up to 3 months. Then your DAX code would have to check each parameter and react differently depending on which one was selected.

This would be pretty advanced, but you could probably do.