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

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