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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.