Slicer related question

Hello Experts, I have a requirement on a line graph to selets the lines based on Slicer value. Below is graph show and a slicer for the month. Each line comes from a separate JSON source for eac...

Tips and Tricks

v-lid-msft

6 years ago

Hi Anonymous ,

We can try to create following measures as value field of line chart to meet your requirement:

April Frequency Measure =
IF (
    ISFILTERED ( 'Months'[Months] ),
    IF (
        "April" IN FILTERS ( 'Months'[Months] ),
        SUM ( '04 April 2019'[Frequency] ),
        BLANK ()
    ),
    SUM ( '04 April 2019'[Frequency] )
)

May Frequency Measure =
IF (
    ISFILTERED ( 'Months'[Months] ),
    IF (
        "May" IN FILTERS ( 'Months'[Months] ),
        SUM ( '05 May 2019'[Frequency] ),
        BLANK ()
    ),
    SUM ( '05 May 2019'[Frequency] )
)

June Frequency Measure =
IF (
    ISFILTERED ( 'Months'[Months] ),
    IF (
        "June" IN FILTERS ( 'Months'[Months] ),
        SUM ( '06 June 2019'[Frequency] ),
        BLANK ()
    ),
    SUM ( '06 June 2019'[Frequency] )
)

July Frequency Measure =
IF (
    ISFILTERED ( 'Months'[Months] ),
    IF (
        "July" IN FILTERS ( 'Months'[Months] ),
        SUM ( '07 July 2019'[Frequency] ),
        BLANK ()
    ),
    SUM ( '07 July 2019'[Frequency] )
)

August Frequency Measure =
IF (
    ISFILTERED ( 'Months'[Months] ),
    IF (
        "August" IN FILTERS ( 'Months'[Months] ),
        SUM ( '08 August 2019'[Frequency] ),
        BLANK ()
    ),
    SUM ( '08 August 2019'[Frequency] )
)

September Frequency Measure =
IF (
    ISFILTERED ( 'Months'[Months] ),
    IF (
        "September" IN FILTERS ( 'Months'[Months] ),
        SUM ( '09 September 2019'[Frequency] ),
        BLANK ()
    ),
    SUM ( '09 September 2019'[Frequency] )
)

Best regards,