How can I Show 1 of 2 columns in a table based on a slicer

[LDEVIN]

Simple problem :).  Your help is appreciated

I have a Fahrenheit column and a Celsius column of data.  Depending on a slicer value, I would like to show only one of these columns.  Is that possible?  If so, how :).  

Thanks in advance

LD

[MFelix · Accepted solution]

Hi @LDEVIN,

In the video link you have the type of calculations and setup you need to do make it work.

Regards,

MFelix

[LDEVIN]

this may work, but I can't add data as suggested due to the fact that my data source is an SSAS cube.

[LDEVIN]

I did test this conceptually and it works. Thank you.  I would say, that SSAS cubes means I have to copy the measure to a new measure and add the contains logic.  Thank you.

[LDEVIN]

One last note for anybody else.  This works much better for a graph.   A table will show both columns, but only show the data in the column selected by the chooser.

[MFelix]

Hi @

if you add a measure.that makes a switch between both columns you will only get.one value at a time.and not both.

Something like
Measure = SWITCH( TRUE(),
CONTAINS(Slicer, Slicer[Info],"a"), SUM(Table[a]),
CONTAINS(Slicer, Slicer[Info],"b"), SUM(Table[b]),
"No selection"
)

You need to use these measure on your table instead of the original columns to only have a single result.

Change the tables and colums to what you need
Regards,
MFelix