switch between two y-axis columns

Question

Hello, so I have a line graph. on the y-axis is a set of data set by a spesific unit. I would like to be able to switch from the current unit of data to a diffrent unit of data, is there a way to change over without editing in the visualizations tab under " Values". Currently i have two columns that convert the data to one unit or the other .

End goal is to let the user choose what units they would like to see the data presented in , ex: inches or cm.

All help is great! thanks.

- Collin

dedelman_clng · Answer

You will need to create a slicer with the different options you want, create a measure off of that slicer indicating what value is picked, then a measure that will calculate your value in various units&nbsp;Measure to&nbsp;indicate chosen valueMType = SELECTEDVALUE(Slicer[Field])Measure for bar or lineBar/Line Value = 
SWITCH (
    [MType],
    "Value1", [Measure Unit 1],
    "Value2", [Measure Unit 2],
...
)&nbsp;Hope this helpsDavid&nbsp;

dedelman_clng · Answer

Here is how I have done it previously:&nbsp;I create a table "Unit Type" with one column "Type" and 2 values:&nbsp;VolumeEnergy&nbsp;I then create a measure on that table&nbsp;MType = SELECTEDVALUE('Unit Type'[Type])'Unit Type'[Type] will populate your slicer.&nbsp;On the fact table, I create a measure that switches between calculations based on the value selected in the slicer&nbsp;Total Volume = 
SWITCH (
    [MType],
    "Energy", CALCULATE (
        SUM ( FG[Volume] ),
        UoM[Unit of Measure] = "MMBTU"
    ),
    "Volume", CALCULATE (
        SUM ( FG[Volume] ),
        UoM[Unit of Measure] = "MSCF"
    )
)SWITCH() is a multi-part IF statement. See this link SWITCH() for more information.&nbsp;If you're still having trouble, see this link to give the community all of the necessary information:https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490&nbsp;David

anonymous · Answer

dedelman_clngI am very confused on how to do this.&nbsp; I tried creating measures but it will not alllow me to add my columns that hold the unit&nbsp; conversions.&nbsp; one column take the value and converts it if not already to inches and the other column converts to centimeters if not already.&nbsp; Also i have never incoperated a slicer in to a spesific calculation before . Could you explain alittle what the "slicer [Field]" is&nbsp; and the switch statement measure . thanks for the help!&nbsp;&nbsp; &nbsp;- Collin

anonymous · Answer

dedelman_clngI dont want&nbsp; to bother much more, just one last question on your setup , what is FG[volume] in the sense that[name]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; is a measure'Table'[name]&nbsp; &nbsp; &nbsp; is a table columnwhat isname[name]&nbsp; &nbsp; &nbsp; &nbsp;??&nbsp;unit choice&nbsp;= &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [MType],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "dBuA",&nbsp; 20 * LOG10('Table1'[RequirementLevel]) + 60) ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "mA"&nbsp; &nbsp;,&nbsp; POWER(10, ( ('Table1'[RequirementLevel] - 60) / 20) ))&nbsp;this is my switch statement right now,I Continue to get this error: "A single value for column 'RequirementLevel' in table 'Table1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."&nbsp;sorry to bother, very greatful for the help.&nbsp;- Collin

anonymous · Answer

Forum Discussion

switch between two y-axis columns

6 Replies

Related content

Alternative to SWITCH ()?

Switch -Containsstring

Order switching mid workflow

Using Switch

Switch Time Zone on DateTime Columns based on User Selection