I have a scatter chart visual with x and y - axis that are actually calculated columns... I'd like this visual to be dynamic.. I have 7 different calculated columns to choose from, so I'd like a user to be able to choose one of 7 calculated columns for X-axis and the same 1 of 7 calculated columns for Y-axis... I was able to achieve that quite easily by creating two slicers that each contain X and Y - axis values (behind each slicer is a table "X Axis Slicer" and "Y Axis Slicer" respectively..) and a measure:
testMeasure = if(SELECTEDVALUE('X Axis Slicer'[X Values]) = "A", CalculatedColumnA,
IF(SELECTEDVALUE('X Axis Slicer'[X Values]) = "B", CalculatedColumnB,
CalculatedColumnC))
So when I use this measure for X and Y - axis on the graph and switch between diff. selections of my X and Y slicers it all works...
However here's the problem: I need to have two more slicers to be able to manipulate the min and max values that are seen on my graph.. When I create a calculated column and use the same If statement as above it doesn't work since Calculated Columns do not see filters... So essentially it always goes to else... (creating Calculated Column and setting it equal to measure works the same, where it no longer sees the filter and goes to else...) Also I can't just use a Measure since Slicers do not work with measures.. One thing that I think could work is if all my Calculated Columns where unpivoted into one big column so the entire table can be filtered down by 1st slicer and then the second slicer can pick up the values.. However since all these columsn I'm using are Calculated columns I cannot see them in Edit Queries.. Also looks like we cannot unpivot using DAX?
Essentially the way this works for me right now is I have my 7 slicers on page and user can pick two... to match the dimensions they've set to see on the graph... Anyway I can get to only have 2 slicers? It seems the problem is circular where all the options I'm trying to do do not work because of something or other....
