Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have 2 tables: Families and Parameters. Each family and each parameter has an assigned category. The categories consist of 3 digits from 1-9, with the possibility of a 0 in position 2, or in positions 2 and 3 in the case of no subcategory. The task is to assign parameters to families. And the biggest problem: the category consists of 3 levels. Not all parameters reach the lower subcategories. This means that they apply to all subcategories. For example, a parameter with a category of 400 (main category 4, 2 unspecified subcategories) applies to all families in the main category 4, i.e., from 411 to 499. But a parameter with a category of 438 applies only to families in the same category. And vice versa: selecting a family with a category of 357, I should get all parameters from the following categories: 357, 350, 300. Because if a parameter has a category of 350, it means it should be assigned to all families with a category of 35x.
How can I visualise it?
I mean to create 2 separate visuals (one common would be nod bad as well): one with families, the second one with parameters. If I chose one familie, I want to se all associated parameters.
I tried with hierarchies (split category into 3 separate columns and set a hierarchy) but I had no idea hot to connect then the tables in the model.
I wrote this in Python, maybe someone can translate it into Power BI?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
130 | |
80 | |
53 | |
38 | |
35 |
User | Count |
---|---|
207 | |
82 | |
75 | |
55 | |
50 |