Forum Discussion

dkrishnan's avatar
dkrishnan
Frequent Visitor
6 years ago
Solved

Power Bi Dynamic Slicer

HI   I have a table with as per below: DATE_CODE PARTNER REVENUE_TYPE HUB PRODUCT COMPONENT_DIRECTION CALL_COUNT DURATION AMOUNT 01-03-2020 A MOBILE EUR AA AB 2000 40000 500 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI dkrishnan,

    You can create a new table with all measure field names and use this table field on a slicer.
    After these steps, you can write a measure formula to compare current slicer seleciton and use with switch function to redirect current value to specific measure formula results.

    Calculate table:

    Selector= {"Measure1","Measure2","Measure3"}

    Measure:

    Measure =
SWITCH (
    SELECTEDVALUE ( Selector[Value] ),
    "Measure1", [Measure1],
    "Measure2", [Measure2],
    "Measure3", [Measure3],
    Sum(Table[Amount])
)

    Regards,

    Xiaoxin SHeng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI dkrishnan,

You can create a new table with all measure field names and use this table field on a slicer.
After these steps, you can write a measure formula to compare current slicer seleciton and use with switch function to redirect current value to specific measure formula results.

Calculate table:

Selector= {"Measure1","Measure2","Measure3"}

Measure:

Measure =
SWITCH (
    SELECTEDVALUE ( Selector[Value] ),
    "Measure1", [Measure1],
    "Measure2", [Measure2],
    "Measure3", [Measure3],
    Sum(Table[Amount])
)

Regards,

Xiaoxin SHeng