Forum Discussion

pxg08680's avatar
pxg08680
Resolver III
8 years ago

Filter Selection

Hi everyone,   I have a slicer which gives me options, vs US Rates and vs Europe Rates.     As you can see, X-axis is Currency Code. With selection "vs USD" I need my X-axis to have fe...
Need Help
Show and Tell
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi pxg08680,

 

I have made a sample table like below based on your description:

 

If my sample data is like yours, then you can follow steps below:

1.Click Edit Queries -> Add Column -> Custom Column to add columns [vs EUR] and [vs USD] using your function.

2.Click columns [vs EUR] and [vs USD], then click Transform -> Unpivot Columns to make column name be row values.

3.Create a slicer on [Attribute] column and a stacked column chart using [Category] as Axis, [Attribute] as Legend, [Value] as Value.

 

 

Regards,

Jimmy Tao

  • pxg08680's avatar
    pxg08680
    Resolver III
    8 years ago

    I appreciate your response but, I have the vs EUR and vs USD values available. All I need is when I select "vs EUR" I need to display certains currencies and for "vs USD" remaining currencies. 

     

    Ex: If I select "vs EUR", the X-axis should have PLN,CZK,CHF,NOK,SEK,GBP

         and for "vs USD" all the remaing currencies.

     

     

    Thank you