Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all
So i have 2 tables in my case. Table 1 contains data of ~10 years, and Table 2 only since 2018.
Table 2 contains revenue targets, Table 1 is the revenue table. These are connected via an inactive relationship.
This works just fine.
On the page i also have a "Year" slicer, this year comes from table 1, so it shows 2009-2019, but i only want to show years where targets are available, so for this case 2018 & 2019.
Wasnt able to create a column that fullfills my need.
Many thanks
Solved! Go to Solution.
can you refer to https://community.powerbi.com/t5/Desktop/DAX-query-to-compare-a-value-in-one-table-to-see-if-it-exis...
Have you tried to make the relationship both?
Take note that this can slow down the report.
Thank you
Its already on "Both". Single direction didnt work for me (messes up the report)
@Osmanakgunduz this looks pretty good, im getting small differences in my revenue though... But its possible that this is solveable inside my data.
another option is to drag the taget column your date slicer visual and filter it greater than or is equal to 0.
Hello @Anonymous
I suppose you have selected table1 year column in slicer's field. Can you remove this field and drag-drop table2's year column?
Best Regards!
Yes i already tried that, but its not filtering the revenue correctly this way..
can you refer to https://community.powerbi.com/t5/Desktop/DAX-query-to-compare-a-value-in-one-table-to-see-if-it-exis...
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |