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, 

DimaMD's avatar
DimaMD
Solution Sage
3 years ago

Hi alavanka Try creating a Numeric parameter.


Next, you can write a simple measure

= SUM('Table'[Percentage])+[Значення "Параметр"]

I hope I understood your problem correctly

  • 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.

      • alavanka's avatar
        alavanka
        Helper I
        3 years ago

        I think that is it. 🙂 Just wondering if I want to replicate to feature 2 together with Feature 1 in Mipa measure what shall I do?