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
User | Count |
---|---|
73 | |
69 | |
36 | |
26 | |
24 |
User | Count |
---|---|
97 | |
92 | |
54 | |
45 | |
41 |