cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

Accepted Solutions

Re: Date Hierarchy as filter

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
Super User
Super User

Re: Date Hierarchy as filter

Hi @Prakash_Mathi ,

 

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

MFelix


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

Proud to be a Datanaut!




Community Support Team
Community Support Team

Re: Date Hierarchy as filter

Hi @Prakash_Mathi ,

 

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.

Re: Date Hierarchy as filter

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

Re: Date Hierarchy as filter

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors