Changing calendar formula from CALENDARAUTO to CALENDAR

[ickest]

Hi Everyone,

I would like to seek help to the pros here about a certain problem. When I changed the calendar table's formula from CALENDARAUTO to Calendar, all my visuals date axis changed. Is there a work around on this?

 Thank you in advance!

[Syndicate_Admin]

The same thing happened to me.
You must pause the visuals to refresh before making any changes to the calendar formula.

Once you have made your changes, resume updating your visuals.

[v-xulin-mstf]

Hi @ickest,

Is your issue solved?

If the issue has been solved, please adopt the solution to help others

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[parry2k]

@ickest not sure I followed your this comment:

problem is tooltip would be daily also, like you will see 1/1/2020, 1/2/2020, and so on. So you still need to change the date period on the axis value again (for each chart/visual).

[parry2k]

@ickest understood and I'm also a bit surprised with this behavior, CALENDARAUTO and CALENDAR both creates a date column in the table with the data type date, not sure why it will not change the x-axis to categorical. Did by chance you changed the data type for the date column? Also if you change x-axis type to continuous (for testing purpose), does it works?

[ickest]

Yeah it does work, problem is tooltip would be daily also, like you will see 1/1/2020, 1/2/2020, and so on. So you still need to change the date period on the axis value again (for each chart/visual).

[ickest]

The problem is I already have this visuals made and would take time to format each visual. I am changing the calendar table's formula since there are some inconsistencies. I am actually seeking a way to do this without messing with my visuals (since it was okay before even if they are not continuous). Thank you for the help tho!

[parry2k · Accepted solution]

@ickest yes, if you want to show the visual the way you want, you have to change it to continuous, and this option wherever available, only available when you are using date or number type column on the x-axis, not for text. FYI

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[ickest]

Hi some charts have this option, some don't. So I need to format all my charts to continuous?

[parry2k]

@ickest Make sure on format pane, under x-axis, type is set to continuous not categorical.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡