Update table using slicers

[alavanka]

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 calculation and the total represents 100%:

What I would like to know if it's possible to manipulate the weight of each Feature by changing the percentage using a slicer or something and at the same time guaranteeing that the total doesn't exceed 1 or 100%.

best regards!!

[DimaMD]

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]

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]

@alavanka Look at this file, I fixed the parameter and wrote the measure. Please review

[alavanka]

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?

[DimaMD]

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

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

[alavanka]

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 · Accepted solution]

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

[alavanka]

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

[FreemanZ]

If you mean Query in Power Query, no;

If you mean native or calculated table in Power BI, no;

But if you mean Table Visual in Power BI, yes, as long as the field you use in the slicer is relevant to the fields in the Table Visual. 

[tamerj1]

Hi @alavanka 
Would you please provide an example?

[alavanka]

Not sure how to provide an example... 

Imagine having a report where I could use some kind of a numeric range slicer to change weight of Feature 1 from 0,03 to 0,2.

But in other hand having some kind of way to prevent of exceed the total of 1 (sum of all the percentages).

[tamerj1]

@alavanka 
I don't want to say this is not possible rather I would say I don't know.