Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have data coming from Analysis Services with non-unique dates. My intention is to enable drill-through like Year-Quarter-Month-Week-Day. I have read qiute a lot of info, some of it contradictive, some out of date, so I would apreciate if someone could explain to me please how to create drill-through.
I have generated a table with unique dates, which I then linked to my main table. I have created a hierarchy. However, when I drop all the variables into Rows, I get the attached, and I just can't quite put my finger on what is missing. It sort of looks like a drill-through but somehow it seems that it's wrong.
Solved! Go to Solution.
@tpoltorak , I think you need Custom Hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY
@tpoltorak , I think you need Custom Hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY
Thank you for your help. Yes, a custom hierarchy was what I was looking for. The video was very helpfull.
What I need is someting like this. All the parts of a date should be inside one grey rectangle.