Forum Discussion
Parameters and matrix
I created a Matrix that has a hierarchy on both rows and columns. The intersection of a row and a column generates a cell with an associated value. I would like to add a parameter to any of these cells so I can see what happens on a parent cell if I increment a child cell. Is that possibile? This is possible with valQ (they give me a filter for any cell and I can move the slider left or right to simulates changes) but in valQ I can't achive a matrix vizualisation (I can only have rows or column, not both)
9 Replies
Hi Anonymous ,
Could you please share some data and screenshot to explain your requirement?
Best Regards,
Teige
I consider that the first column is my hierarchy, second column is a parameter that i can change, third represents the values.
This report was done in Power Bi with ValQ (that object doesn't permit me to add an another herarchy on the columns, so I can't keep it like that but I need to integrate this solution in a Matrix object)
That view is the normal one (without changes):
The second view represents my what if analysis, what happens if I increment or decrement the value of a node(Would also be nice to see what happens on nodes if I change parents values, based on a rule that could be proportionality). In this case I incremented "prestiti e anticipazioni" by 48,31%:
