Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
aas_nordea
New Member

Date hierarchy on column

Hi,

I have a model with a date dimensjon table connected to facts, but I also have an agreement dimension table. The agreement table has a opening date column which I would like to use as a filter/slicer. But when I do I would like to quickly choose spesific years and or months, without having to click on each individual date. I would like to do this without having a relationship or using TREATAS to the datetable because I still want that as a separate filter.

 

Can anyone help me solve his? Do I have to create year, month columns in the agreement table? I have access to Tabular Editor if that helps..

 

Regards,
Anders

 

no.jpgyes.jpg

1 ACCEPTED SOLUTION
isjoycewang
Solution Supplier
Solution Supplier

Hi @aas_nordea,

 

Please change your [Agreement Effective Date] data type to "Date" in the column tools, and then you should be able to see automatic date hierarchy which you can put them into the slicer. 

isjoycewang_0-1700056704827.png

 

 

 

If you don't find automatic hierarchy for your date column, please try to tranform it in the Power Query editor or refer to below artical: https://community.fabric.microsoft.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682

 

Best Regards,

Joyce

View solution in original post

1 REPLY 1
isjoycewang
Solution Supplier
Solution Supplier

Hi @aas_nordea,

 

Please change your [Agreement Effective Date] data type to "Date" in the column tools, and then you should be able to see automatic date hierarchy which you can put them into the slicer. 

isjoycewang_0-1700056704827.png

 

 

 

If you don't find automatic hierarchy for your date column, please try to tranform it in the Power Query editor or refer to below artical: https://community.fabric.microsoft.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682

 

Best Regards,

Joyce

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.