Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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.
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |