The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
I have created a Parent-Child hierarchy for my chart of accounts. I want to be able to add the hierarchy structure to a slicer and then have the ability to filter by either the parent or child. I have set the filter relationship between my fact table and Accounts dimension table to go bothways and for that reason i can only see accounts that have transactions booked on them. this cuased the Parents of the child acocunts to not show in my slicer, but I would like to see the parents of children with transactions within them.
How to Get Your Question Answered Quickly meaning please add your work-in-progress Power BI Desktop file and data source in Excel format. Please format any DAX measures using short lines for the reader.
User | Count |
---|---|
69 | |
63 | |
59 | |
55 | |
28 |
User | Count |
---|---|
183 | |
80 | |
62 | |
46 | |
38 |