Forum Discussion
Axe X and Y with the same table same column
Helper IIi guess you need to transform your data source in [attribute] [x] [y] so having 3 columns, preferably you do that in the query editor, or in your database/excel if possible
For the moment to solve this, I am looking to create a formula. I have a slicer with an attribute value called AttrX. It contains a column of AttrX data that has different attribute names. For example A, B, C, D etc. In the same table called: view_dim_measure_resultX, I have a value: ValueX. Which has a different value per attribute. I would like to create a new measure that will be called X and that will set all the values of X to zero if it is not selected in the slicer. and all the values of ValueX in X if it is selected in the slicer. So for example if I select A and D in the slicer, in my table I want to see A = the value of ValueX, D = the value of ValueX and the other attributes = 0 for each line/attribute. Considering that I want to see these results in a graph or a table that should not be filtered only on the selected values since I want to see all the attributes even if they are not selected and that their X value is therefore zero.