Forum Discussion

AntonioTG's avatar
AntonioTG
New Member
9 years ago
Solved

Line chart slicer

Hello, I am new creating Power BI reports, my apologies if my question sounds stupid. I am trying to add a line chart tile with 3 lines, that are shown by default. That is "Value1", "Value2" and "...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi AntonioTG,

     

    If I understanding correctly, the line chart displays three lines by default without any selection, and if you select a specific value from slicer, this chart should be automatically updated with only the line based on selection.

     

    Below is my test, please review it.

     

    Create an extra table which includes one column to list the available selections in slicer.

     

    Create three measures that will be added into "Value" field of the LineChart. You should change the column name ('total per row[expected]', 'total per row[atual]', 'total per row[Amount]') according to your own scenario.

    Value1 =
IF (
    LASTNONBLANK ( 'Select'[Select], 1 ) = "Value1",
    LASTNONBLANK ( 'total per row'[expected], 1 ),
    IF (
        ISFILTERED ( 'Select'[Select] ) = FALSE (),
        LASTNONBLANK ( 'total per row'[expected], 1 ),
        BLANK ()
    )
)

Value2 =
IF (
    LASTNONBLANK ( 'Select'[Select], 1 ) = "Value2",
    LASTNONBLANK ( 'total per row'[atual], 1 ),
    IF (
        ISFILTERED ( 'Select'[Select] ) = FALSE (),
        LASTNONBLANK ( 'total per row'[atual], 1 ),
        BLANK ()
    )
)

Value3 =
IF (
    LASTNONBLANK ( 'Select'[Select], 1 ) = "Value3",
    LASTNONBLANK ( 'total per row'[Amount], 1 ),
    IF (
        ISFILTERED ( 'Select'[Select] ) = FALSE (),
        LASTNONBLANK ( 'total per row'[Amount], 1 ),
        BLANK ()
    )
)

    I can get the expect line if I select "Value2".

     

    Best regards,
    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Could anyone please expand on the possibility of selecting multiple measures in a visual using the above-explained approach?

 

The most recent answer to the multiple selection question referred to the properties pane which is to my understanding no longer available in the current PBI desktop version. 

  • r4v3n's avatar
    r4v3n
    New Member
    3 years ago

    As i was passing by this topic for my own interest, i encountered the same issue and was able to find a solution, here is what you were looking for  : 

     

     

    Value1 =
IF (
    LASTNONBLANK ( 'Select'[Select], 1 ) = "Value1",
    LASTNONBLANK ( 'total per row'[expected], 1 ),
    IF (
        CONTAINS(ALLSELECTED('Select'[Select]), [Select], "Value1"),
        LASTNONBLANK ( 'total per row'[expected], 1 ),
        BLANK ()
    )
)

     

     

    This will allow for multiple selections.