Forum Discussion

HELPMEo_o's avatar
HELPMEo_o
Frequent Visitor
4 years ago

Joining two columns?

I have a dataset with a bunch of columns that list out ratings from 0 to 3000 down the rows, with playerID as the first column. I created 2 pseudo table that holds all of the column names other than...
v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi HELPMEo_o ,

 

You are making a rather serious mistake, measure cannot return multiple values.

 

I think you want to display the x and y axes dynamically. visual works by displaying all the data of the fields one by one in the visual, and if there are filters applied to this visual, for example if you have filtered the x axis with slicer, it will only display the parts that match the slicer selection. So the effect of displaying the visual dynamically is achieved.

 

So, you can create a measure let the x-axis's data or value do not match the condition.

measure =
IF(
    SELECTEDVALUE( 'table1'[X Axis] ) = SELECTEDVALUE( 'table2'[sXTest] ),
    1,
    BLANK()
)

Then add the measure to the filters pane on this visual. And set show items where is 1.

 

If you need more help, please share some sample data.

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.