switch button

[vjnvinod]

Hi Community,

I need to create a switch button/dropdown slicer, name of the switch button/dropdown should be variance$ and Variance%

don't prefer bookmark option, what is the other way to achieve that? here is my graphs below.

customer wants to see one at a time, so when he/she selects variance$, it should bar graph with dollar value and vice versa

[tex628]

Create a small table with a 2 cell column, "$" & "%". 

Use this column in a slicer.

Create 2 measures, both using a selectvalue() to determine the selected variance. 

The measures should return the relevant value if the correct variance is selected, otherwise they should return BLANK().

Finally use both measures in the same graph. One should give you a value and one should return blank, depending on the selection.

To my knowledge there is no way to swap between % and $ on a single measure.

[Anonymous]

Hi @vjnvinod ,

Besides bookmark method, you can create a new table with a column, in that column you may create 2 values:

variable % and variable $.

Then put the column as a slicer, it's a single-selected slicer.

In your measure, you can write:

if(max(your_column_name) = "variable %", your % expression, your $ expression)

Please try

Aiolos Zhao