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.
Hi All,
I am very new to power BI. I searched the whole power BI community.
This is quite urgent.
I have a dimension table 'DIM_DATE' with D_KY, YR, MTH columns. I have a fact table 'Sales' with multiple columns D1_KY, D2_KY... which are FKs (Many to one relation wih D_KY of DIM_DATE). Now I need a slicer with values from YR column that are present in Fact table only but not all the YR values from the DIM_DATE. I have already tried cross filter(both)option, it isn't working and I shouldn't use 'Merge' to do this.
I need the slicers as below.
Slicer 1 - Show YR based on DIM_DATE.D_KY=Sales.D1_KY
Slicer 2 - Show YR based on DIM_DATE.D_KY=Sales.D2_KY
Appreciate all the help.
Thanks,
S
@Anonymous , Join both dates with date table one join will be inactive. you can activate that in measure using userelationship
refer
example
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
27 | |
26 |
User | Count |
---|---|
97 | |
96 | |
59 | |
44 | |
40 |