Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey, let's consider this simple star model shema:
The result I'm trying to achieve is a sales table that I can filter by 3 type of owners:
Owner table is related to Client, Product and Sale table.
There are 2 ways I can make relations:
1) Duplicated dimention table
2) Single dimention table and inactive relationships
On the first examples, 3 different slicers are no problem at all. But is this even possible in the second example?
Hi @barwe
It sounds like role-play dimensions, please refer to the linked videos :
https://www.youtube.com/watch?v=2BxaUXlx3K4
https://www.youtube.com/watch?v=H3-evk6-qpQ
The way that you should choose depends on the visuals and measures that you will need.
Take a look at the linked article too:
https://www.nathanprats.com/date-tables/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |