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!!

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

Update table using slicers | Microsoft Fabric Community

12 Replies

tamerj1
Community Champion
3 years ago
Hi alavanka
Would you please provide an example?
- alavanka
  Helper I
  3 years ago
  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
    Community Champion
    3 years ago
    alavanka
    I don't want to say this is not possible rather I would say I don't know.
FreemanZ
Super User
3 years ago
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.
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

parameter.pbix27 KB
- 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
    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]), [Міра]))