Filter to select which column I want to display

[Anonymous]

I have these two columns, "CONAMA" and "COPAM"

I need to create a line chart with these two columns.

However it must be a single line where I will have a filter (slicer) that if I select CONAMA it returns me the value of CONAMA and if I select COPAM it returns me the value of the COPAM column

I cannot pivot the columns in rows because I have already pivoted in other columns, it would not work

[camargos88 · Accepted solution]

Hi @Anonymous ,

I believe this is what you are looking for: https://www.thedataschool.com.au/danica-hui/switching-measures-and-titles-dynamically-in-power-bi/