Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have 1 fact and 3 dimension table and source system is BW.
L1,L2 and L3 are hierarchy table between them. I don't combine these tables, because i add new fact tables with different granularity. however i want to select a value from L1, then L2 is filtered by L1 table selected value.
How can i do this?
Regards.
Remove your relationship between L1 and R87, this will make the relationship between L1 and L2 active, which in turn filters R87.
I feel like these tables are named after droids...
Hi,
The Real scneario is below, i have 3 fact table table has 3 different graniluty,
DimAltGrup, DimGrup and DimAnaGrup tables have hierachy between them.
At the presentation layer,i have 3 dropdown list and i want to have relation between them.
The model below, Dim Group DropDownList is not filtered by when i select a value from DimAnaGrup
Hi @unalyigit,
Your two snapshots are quite different. If it's the latter, you just need to establish proper relationships among "DimAnaGrup", "DimGrup" and "DimAltGrup".
Best Regards,
Dale
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |