Forum Discussion

sam_gift's avatar
sam_gift
Icon for Helper I rankHelper I
2 years ago
Solved

Line Chart: Show only end data points for the last days

Hi,

 

I have a line chart, where I have different data points as the below screenshot, I am happy with the overall data points but As at the end, the numbers look clumpsy and I observed that each line have 2 data points displayed at the very end. I want to show only one data point the end of the line (for the box B) along with all the data points from box A.

Please help

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago
    You can use conditional formatting functionality to achieve this goal.
    Create the measure that returns color based on last point checking like:
     
    maX year_color =
    var
    Max_yeaar=
    CALCULATE(MAXX(values('Calendar'[Year]),MAX('Calendar'[Year])),ALLSELECTED('Calendar'))
    return
     IF(SELECTEDVALUE('Calendar'[Year])<>Max_yeaar,"#FFFFFF00"
    ,"black")

    Use this measure for conditional formatting of label color :

    Result:

     

    The pbix with the example is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

     

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago
    You can use conditional formatting functionality to achieve this goal.
    Create the measure that returns color based on last point checking like:
     
    maX year_color =
    var
    Max_yeaar=
    CALCULATE(MAXX(values('Calendar'[Year]),MAX('Calendar'[Year])),ALLSELECTED('Calendar'))
    return
     IF(SELECTEDVALUE('Calendar'[Year])<>Max_yeaar,"#FFFFFF00"
    ,"black")

    Use this measure for conditional formatting of label color :

    Result:

     

    The pbix with the example is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.