Forum Discussion

AtchayaP's avatar
AtchayaP
Icon for Helper V rankHelper V
4 years ago
Solved

Powerbi slicer

abgnfirdaus  did you get answer for this? Even I'm trying I couldn't.

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  AtchayaP ,

    Here are the steps you can follow：

    1. Select three columns in Power Query – Unpivot Columns.

    Result：

    2. Use Enter data to create data.

    3. Create measure.

    Measure =
var _select=SELECTEDVALUE('Slicer_table'[Slicer])
return
IF(
_select ="Territory2",
SUMX(FILTER(ALL('Table'),'Table'[Attribute]="Territory2"),[Value]),SUMX(FILTER(ALL('Table'),'Table'[Attribute]=MAX('Table'[Attribute])),[Value]))

    4. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  AtchayaP ,

    Here are the steps you can follow：

    1. Select three columns in Power Query – Unpivot Columns.

    Result：

    2. Use Enter data to create data.

    3. Create measure.

    Measure =
var _select=SELECTEDVALUE('Slicer_table'[Slicer])
return
IF(
_select ="Territory2",
SUMX(FILTER(ALL('Table'),'Table'[Attribute]="Territory2"),[Value]),SUMX(FILTER(ALL('Table'),'Table'[Attribute]=MAX('Table'[Attribute])),[Value]))

    4. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly