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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Date Hierarchy as filter

Hi All,

 

Generally we will get date hierarchy as Year,Quarter,Month and Day. Is it possible to have these 4 values in filters under date column so that if i select "Day' then it need to show data on daily basis and when i select "Month" then it will be showing data on monthly basis.

 

We can do this with the help of button using bookmark but i would like to have these 4 values in a slicer i.e., filters.

 

Thanks in advance.

 

Regards,

Prakash

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi Guys,

 

I got the solution. I was facing problem similar to the below link.

https://community.powerbi.com/t5/Desktop/Column-Selection-using-a-Disconnected-table/td-p/606303

 

Thanks for your respose.

 

Regards,

Prakash

View solution in original post

4 REPLIES 4
v-lid-msft
Community Support
Community Support

Hi @Anonymous ,

 

Do you want to change the column in table visual based on the value you selected in another slicer?  Or expand columns?

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi Guys,

 

I got the solution. I was facing problem similar to the below link.

https://community.powerbi.com/t5/Desktop/Column-Selection-using-a-Disconnected-table/td-p/606303

 

Thanks for your respose.

 

Regards,

Prakash

Anonymous
Not applicable

Hi All,

 

Is there any other way apart from this? Please refer the below URL

https://community.powerbi.com/t5/Desktop/Column-Selection-using-a-Disconnected-table/td-p/606303

 

Can we do it without duplicating the record or without creating the bridge table?

 

Regards,

Prakash

MFelix
Super User
Super User

Hi @Anonymous ,

 

The date hierarchy that is created on PBI is a virtual one and does not result from different columns in the database but from the date columns.

 

For having this type of slicer (Day, Month,Quarter, Year) you need to create a disconected table on your model and then make your measure to work uppon this nem table.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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