Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
bayarri81
Frequent Visitor

How to show two selected values from a slicer in a lines graph

I'd like to show two selected values from a slicer that has four options in a lines graph. I'm using the next measure to select only one of them. Thanks in advance.

 

 
Valor año seleccionado =
 VAR ValoresSeleccionados = COUNT('Selección Eur-Kgs'[Selección])
 VAR Seleccion = SELECTEDVALUE('Selección Eur-Kgs'[Selección])
 VAR TotalEuros = [Vtas Sem]/1000
 VAR TotalKilos = [Kgs Sem]/1000
VAR Totaluds = [Uds Sem]/1000
VAR Euroskilos = [Euroskilos Sem]
 VAR Valor_Mostrar = IF (
     ValoresSeleccionados=4,
            TotalKilos,
         If(Seleccion="Vts",TotalEuros,
         IF(Seleccion="€/K",Euroskilos,
        IF(Seleccion="Uds",Totaluds,
       TotalKilos)
        ) )
    )
       
       
       
       
        RETURN Valor_Mostrar
4 REPLIES 4
tamerj1
Super User
Super User

Hi @bayarri81 
Place 'Selección Eur-Kgs'[Selección] column in the legend and select the two options from the visual level filter pane.

I had thought just that, but in the chart I show another measure LY.

@bayarri81 
Then what is the reason for sharing the code of this measure? What is the code of LY measure?

I have a chat like this, where I try only one value from the slicer. The new situation is that I want to selected two of them to compare:

gràfic.jpg

 

 

The LY code is the following:

Valor año anterior =
 VAR ValoresSeleccionados = COUNT('Selección Eur-Kgs'[Selección])
 VAR Seleccion = SELECTEDVALUE('Selección Eur-Kgs'[Selección])
 VAR TotalEuros = [Vtas Sem -1a]/1000
 VAR TotalKilos = [Kgs Sem -1A]/1000
 VAR TotalEurKgs = [Euroskilos Sem -1A]
 VAR TotalUds = [Uds Sem -1A]/1000
 VAR Valor_Mostrar = IF (
     ValoresSeleccionados=4,
            TotalKilos,
        if(Seleccion="Vts",TotalEuros,
        if(Seleccion="€/K",TotalEurKgs,
        if(Seleccion="Uds", TotalUds,
       TotalKilos)
        ) )
    )
       
       
       
       
        RETURN Valor_Mostrar
 
 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.