Forum Discussion

alavanka's avatar
alavanka
Helper I
3 years ago
Solved

Update table using slicers

Hello all!   is it possible to change values in a table using slicers?   For example I have a table in my report that I created manually and represents the weight of each feature in my calculatio...
  • DimaMD's avatar
    DimaMD
    3 years ago

    alavanka if I understand you correctly, then you need 6 parameters that you will set, 

alavanka's avatar
alavanka
Helper I
3 years ago

Hello DimaMD ,

thank for your reply!

it seems the solution (if possible) its close to the one you suggested. However the Mipa measure changes the values in every row and not in one specific row (I need to have one fixed slice per Feature).

 

I tried to adjust the measure to just change the sum of Feature 1 but the behaviour is strange... it only changes feature 1 but it doesn't sum up the values like I was expecting...

 

 

Maybe the solution is very simple but I am not able to solve it... my knowledge is very limited. 😞

DimaMD's avatar
DimaMD
Solution Sage
3 years ago

alavanka If you want to see the total, then you need the next measure 

Міра 2 = 
IF( HASONEVALUE('Table'[Feature]),
[Міра],
SUMX( VALUES('Table'[Feature]),
[Міра]))

  • alavanka's avatar
    alavanka
    Helper I
    3 years ago

    Sorry. I was not clear. I need an independent slicer for each feature / row. 

    I just tried for Feature 1 (1st row) assuming that I could replicate the same for the others.

    • DimaMD's avatar
      DimaMD
      Solution Sage
      3 years ago

      alavanka if I understand you correctly, then you need 6 parameters that you will set, 

      • alavanka's avatar
        alavanka
        Helper I
        3 years ago

        That is it! Perfect! I would take 100 years to get it by myself... 🙂 Thanks and keep the good work!