Forum Discussion
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 ...
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
MFelix
Super User
Super UserHi 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