Use slicer to change values of rows, while not removing the others

[ingvild_eline]

Hi, 

I have a problem using my slicer only to switch the value of a row between two columns, while keeping the other values in my visual.
 

You can see the slicer below:

In the table below, "Mål 4" change between the value of "Referanseverdi" when I am not choosing the "Sektor" in the slicer above, and " Tiltaksbane.tiltaksverdi" when I choose the "Sektor" in the slicer above. My problem is, I want to keep the original values of the rows that are not chosen. Right now, they disappear when I do not select them. 

My ultimate goal is to make the "mål 4" graph below change dynamically according to my choices in the slicer.

I appriciate the help.

[v-chenwuz-msft · Accepted solution]

Hi @ingvild_eline , 

Is that you want to the "Mål 4" change to " Tiltaksbane.tiltaksverdi" values the category is selected in the slicer.

First, you need to create a table for slicer to select the Sektor via Slicer = values('table'[Sektor])

Then, a measure like the following to calculate the Mål 4

Mål 4 =
IF (
    ISFILTERED ( slicer[Sektor] ),
    CALCULATE (
        [Measure2],
        FILTER ( 'Table', [Sektor] IN VALUES ( slicer[Sektor] ) )
    ),
    [Measure1]
)

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[ingvild_eline]

Hi, thank you for your answer. I am a bit unsure if that will solve my problem, mabye I did not formulate my question well. My problem is that I have two columns that I fetch values from. Initially all values are fetched from column one and added together, but if I choose a category in the slicer I want to fetch values from the second column for the chosen category, and then add them together with the other values. Thus I want to change the values of rows corresonding to the selected category. Is this possible?

[amitchandak]

@ingvild_eline , Based on what I got, check if field parameters can help

https://medium.com/@amitchandak/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9a...