Forum Discussion
sam_gift
Helper I
Helper ILine 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 l...
- Hi sam_giftYou can use conditional formatting functionality to achieve this goal.
Create the measure that returns color based on last point checking like:maX year_color =varMax_yeaar=CALCULATE(MAXX(values('Calendar'[Year]),MAX('Calendar'[Year])),ALLSELECTED('Calendar'))returnIF(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.
Ritaf1983
Super User
Super UserHi sam_gift
You can use conditional formatting functionality to achieve this goal.
Create the measure that returns color based on last point checking like:
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.