Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |