markup settings error on sudden

[xangetsu21]

i have this line charts on power bi with dates on x axis. i have been adding a markup color for specific date on each month to highlight a specific date on the chart. it was fine until last month but when i tried to add it this month its only showing last 60 instance of dates on the markup option. but it goes all the way back to january and i added the markup color on last month as you can see in the image. but now its only showing dates until march 22 on the markup option of visuals tab but even the chart already has one on august 8th which i added last month from this same markup option. i got no idea whats causing this and whats the solution. and for the second image, the markup setting is showing the line element instead of the date. i added markup using date here last month too which is still visible in the chart but its not available on the settings now. whats wrong and how can i solve this issue? please help

[Anonymous]

Hi @xangetsu21 ,

You could try the following steps for troubleshotting:

Ensure that you are using the latest version of Power BI. Sometimes, bugs are fixed in newer updates.
Try clearing the cache of Power BI. This can sometimes resolve issues related to data not displaying correctly.

Also check if any filters applied in your report that caused this issue.
If the issue persists, try recreating the visual from your report. This can sometimes reset any underlying issues.

Best Regards,

Stephen Tao

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

[xangetsu21]

i tried all of them and even when i make new line charts it shows only first 60 days on the markup color option. and my power bi is updated to the latest i think its the bug on the latest version since i have been doing this report for more than a year and never faced this issue before

[amitchandak]

@xangetsu21 , Create a measure for the date you want to markup and then create a measure to set up color. Convert the line to bar and use that measure in conditional formatting using the field value option now convert the Bar back to line and this will give you colored markers  

example

Color Date =
var _min =minx(allselected(Date,Date[Year])
return
Switch( true(),
FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"lightgreen",
FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"blue",
"red")

Colour =
SWITCH(TRUE(),
'Table'[Date] < TODAY(), "red",
'Table'[Date] = TODAY(), "orange",
"green")

Colour =
SWITCH(TRUE(),
max('Table'[Month Year]) = "Jan-2020", "red",
Max('Table'[Month Year]) < "Feb-2020", "orange",
//keep on adding
"green")

How to do conditional formatting by measure and apply it on pie and line?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[xangetsu21]

this will be a lot of measures and i have already lots of them in the report. and i dont want to be a bar chart, it has to be a line chart. my question is when did they change it and WHY? it doesnt make any sense. is it a bug that they are gonna fix in the next update? you can already see on the images there are already markup color on previous dates which i added using the same markup settings and at that time it showed all the dates that were on the table, not just the first 60. and for the second one, i dont get it why would someone want markup color for the line element when there is already line color for it? IT DOESNT MAKE ANY FREAKING SENSE!!!