Skip to main content

Power BI

New

Support the Persian Solar Hijri Calendar in Power BI

Vote (210) Share
Vahid Doustimajd's profile image

Vahid Doustimajd on 15 Feb 2023 11:33:30

As an Iranian user of Power BI, I would like to see support for the Persian Solar Hijri calendar in Power BI. Power BI and DAX (Time Intelligence) functions do not currently support the Iranian Solar Hijri calendar (or any other calendar that differs from the Roman calendar in structure), so users must either add the Roman calendar and Persian Calendar tables to their model or create a complex date table (mixture of both calendars) and barely use those tables in Power BI. The Persian Solar Hijri calendar is widely used in Iran, Afghanistan, Tajikistan and some other countries, and it is an extremely significant part of the daily life of millions of people.


 


We believe that adding support for the Persian Solar Hijri calendar (or any custom calendars) would be a great addition to Power BI and would greatly benefit Iranian and other users of Power BI. This would make it easier for users to analyze and visualize data based on the Persian Solar Hijri calendar and would help them to make better business decisions.


 


Thank you for your consideration.

Comments (61)
Vahid Doustimajd's profile image Profile Picture

Meisam Mehrvarzi on 25 Apr 2023 04:06:13

RE: Support the Persian Solar Hijri Calendar in Power BI

Please add persian calendar to use time intelligence functions and also filter dates professionally for iranian users.Thanks a lot 🙏

Vahid Doustimajd's profile image Profile Picture

Amin Hadi on 25 Apr 2023 03:41:57

RE: Support the Persian Solar Hijri Calendar in Power BI

Please add persian calendar to use time intelligence functions and also filter dates professionally for iranian users.Thanks a lot 🙏

Vahid Doustimajd's profile image Profile Picture

Zahra J on 24 Apr 2023 19:45:35

RE: Support the Persian Solar Hijri Calendar in Power BI

The existence of Persian Solar Hijri Calendar is very important for Iranian. The lack of this feature has faced us with many problems.We look forward to this feature in the future. Thank you in advance.

Vahid Doustimajd's profile image Profile Picture

Hossein Ayazi on 11 Apr 2023 11:02:53

RE: Support the Persian Solar Hijri Calendar in Power BI

Hi,This idea is so important for Persian users.

Vahid Doustimajd's profile image Profile Picture

Ali Ghaemi on 24 Mar 2023 06:29:57

RE: Support the Persian Solar Hijri Calendar in Power BI

Please,add Persian calendar

Vahid Doustimajd's profile image Profile Picture

Reza Shoja on 18 Mar 2023 08:44:22

RE: Support the Persian Solar Hijri Calendar in Power BI

Same Here!

Vahid Doustimajd's profile image Profile Picture

Alireza Naser on 17 Mar 2023 07:39:54

RE: Support the Persian Solar Hijri Calendar in Power BI

Hi,This idea is so important for Iraninan users.

Vahid Doustimajd's profile image Profile Picture

Gregory Deckler on 13 Mar 2023 03:40:33

RE: Support the Persian Solar Hijri Calendar in Power BI

The real problem with supporting this calendar in a piece of software is that it is observation based, not rule based. Meaning you can't code the exact date and time when Tehran is going to determine the vernal equinox based upon precise astrological observations. I looked into creating a solar calendar but gave up because there is no accounting for human intervention. Code can't account for future events determined by humans so...

Vahid Doustimajd's profile image Profile Picture

Gregory Deckler on 13 Mar 2023 03:26:24

RE: Support the Persian Solar Hijri Calendar in Power BI

Just don't use the built-in TI functions, you can get the same results by not using them. To **bleep** With Time Intelligence - Microsoft Power BI Community. TI functions are generally useless with any kind of fiscal calendar as well so best to avoid them.

Vahid Doustimajd's profile image Profile Picture

Ali Mirkhani on 10 Mar 2023 11:41:24

RE: Support the Persian Solar Hijri Calendar in Power BI

Dear Power BI Developers Team, You don't believe how it would be helpful in our time based analysis, Thanks in advance if you can help us by implementing this feature (Persian Solar Hijri Calendar) to the next releases!

Merged Idea (1)