Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

how to truncate graph

I have a measure f(x) and need to create a line graph. let's say f(0)=0, f(1)=1, f(2)=2, f(3)=2.2, f(4)=2.5, f(5)=2.7, f(6)=3, f(7)=3, f(8)=3...f(21)=3. My end users wants to stop graph at a point when f(x) doesn't change it value. In my example I should show only f(0), f(1)..f(6). They don't want to see f(7) on a graph at all. Is it possible?If possible, how can I modify my function?Thanks a lot in advance!

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    Anonymous 

     

    You may add a new measure and take a look at Show items with no data.

    Measure 2 =
VAR k =
    SELECTEDVALUE ( 'Table'[x] )
RETURN
    IF (
        [Measure]
            <> CALCULATE (
                [Measure],
                TOPN (
                    1,
                    FILTER ( ALLSELECTED ( 'Table'[x] ), 'Table'[x] < k ),
                    'Table'[x], DESC
                )
            ),
        [Measure]
    )

     

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Anonymous 

     

    You may add a new measure and take a look at Show items with no data.

    Measure 2 =
VAR k =
    SELECTEDVALUE ( 'Table'[x] )
RETURN
    IF (
        [Measure]
            <> CALCULATE (
                [Measure],
                TOPN (
                    1,
                    FILTER ( ALLSELECTED ( 'Table'[x] ), 'Table'[x] < k ),
                    'Table'[x], DESC
                )
            ),
        [Measure]
    )