## Desktop

Member
Posts: 61
Registered: ‎09-17-2018

## Re: how to make column optional / selective

@ryan_mayu

Sorry to confuse you, i am using the Unit column to display on a graph,

so basicaly the chart that you created is good, but I need it to affect the graph as well.

I can manualy change the graph by putting the corresponding column in the " values" slot.  but I need a way to have a user do that same thing once the page is published.

Sorry to make this difficult, im trying to learn as I go.

greatly appreciate the help!

- Collin

Member
Posts: 61
Registered: ‎09-17-2018

## Re: how to make column optional / selective

[ Edited ]

@ryan_mayu

Ok , so i figured it out! it was way more simple that what we were trying. I noticed you were using

VAR amount=sum(""Column"")  to basicaly transfer a column, so i did this

Bar/Line Value =
VAR mAamount = SUM('BCI - id 1,3,6,7,8'[mA])
VAR amount=SUM('BCI - id 1,3,6,7,8'[dBuA])
return
IF(selectedvalue(Table1[Units]) ="dBuA", amount,
IF(selectedvalue(Table1[Units]) ="mA" , mAamount,0
))

I created two columns one for each unit that calulated the number correctly. Then the code imports them depending on what is selected. Here are the two calculated columns::

dBuA = IF((NOT('BCI - id 1,3,6,7,8'[Unit] = "dBuA")) , 20 * LOG10('BCI - id 1,3,6,7,8'[RequirementLevel]) + 60  ,
'BCI - id 1,3,6,7,8'[RequirementLevel])

mA = IF((NOT('BCI - id 1,3,6,7,8'[Unit] = "mA")), (POWER(10,(( 'BCI - id 1,3,6,7,8'[RequirementLevel] - 60)/20))),
'BCI - id 1,3,6,7,8'[RequirementLevel])
"front end" table to select what unit to display "back end" the table

thanks for the help , hope this explanation is not as confusing
Established Member
Posts: 183
Registered: ‎09-17-2018

## Re: how to make column optional / selective

@Collin Glad to hear that. You are welcome.

Highlighted
Community Support Team
Posts: 2,954
Registered: ‎02-06-2018

## Re: how to make column optional / selective

Hi @Collin,

It seems that you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.