Select a value column to display with the help of a slicer

[Anonymous]

Hello, 

If I have this type of table (see the screenshot below) is it possible to choose which value to use (the "value1" column or the "value2" column) in a single schema, using a slicer?

Example of the scheme I want to use 

I tried to do it, with the help of a new column "BankCode" but I'm not finding any solutions... 

I hope you understood me,

Thanks, Thomas

[v-yingjl · Accepted solution]

Hi @Anonymous ,

If I got it correctly, you can try the following setps:

1. Create a new table which has a new column 'Value', contains 'value1' and 'value2', just need enter data manually
2. Create a meaure by this formula:

Value = 
IF (
    SELECTEDVALUE ( Test[Value] ) = "value1",
    SUM ( 'Table'[Value1] ),
    IF ( SELECTEDVALUE ( Test[Value] ) = "value2", SUM ( 'Table'[Value2] ) )
)
​

• Put this measure in the Values field of the column chart, create a slicer and put the 'Value' column in it
• The result may like this:

Sample file is attached that hopes to help you, please check and try it: Select a value column to display with the help of a slicer.pbix 

By the way, why the value1 in your picture is the same value each year...not certain

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for your help, I would have never find it myself ! 

It work perfectly, that's so great !

Thanks again, Kind Regards,

Thomas

[amitchandak]

@Anonymous , refer to this topic,  how slicer has been used to chance column or measure

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

[parry2k]

@Anonymous it is not very clear what you are actually looking for, Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490