The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I need my slicer to have a YTD option along with months for the year. So for this example YTD would be 2024 Jan-Jun. Does anyone know how to accomplish this
Solved! Go to Solution.
Hello @U156531 ,
you have to create a new calculated table and that need to be connected with your calendar table with Bi-Direction filtering.
Your new calcualted table should have below similar calculation:
Slicer Table =
UNION(
ADDCOLUMNS(
DATESYTD(CALENDAR_TABLE[DATE]),
"Period","YTD",
"Order",1),
ADDCOLUMNS(
CALENDAR(MIN(CALENDAR_TABLE[DATE]),MAX(CALENDAR_TABLE[DATE])),
"Period","DATES",
"Order",2)
)
Now select Period column and sort by Order column and then use this Period column in the slicer. Dont forget about creating relationships 🙂
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Hello @U156531 ,
you have to create a new calculated table and that need to be connected with your calendar table with Bi-Direction filtering.
Your new calcualted table should have below similar calculation:
Slicer Table =
UNION(
ADDCOLUMNS(
DATESYTD(CALENDAR_TABLE[DATE]),
"Period","YTD",
"Order",1),
ADDCOLUMNS(
CALENDAR(MIN(CALENDAR_TABLE[DATE]),MAX(CALENDAR_TABLE[DATE])),
"Period","DATES",
"Order",2)
)
Now select Period column and sort by Order column and then use this Period column in the slicer. Dont forget about creating relationships 🙂
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
User | Count |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |