Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have uploaded screenshot of my data what i am working on i will eplain about it
So we have person as category and a b c d types what they worked on and on report we make a slicer to change columns like if we select A it will show only column A for that person and i want percentage between 2022 dates and 2023 dates like week to weeks as well as months to months whatever month or week i choose and here we can see i have like 2022 january and 2023 january very far i want it like
2022 jan 2023 jan and 2022 feb 2023 feb and 2022 march 2023 march like this as weeks like compare column just next to it instead of that far could anyone help me overcome this problem
thanks in advance
@GuyInACube @amitchandak @NotGregDeckler @Tiger2514555
If you use the multi-select slicer then use it for a year Then you choose the month that needs to be displayed.
like this
alot of dates like that what i thought is first convert that to month and years and weeks because i dont need data for that but when i am calculating percentage its giving me strange values then the original one and it also showing percentage for 2022 data i need like this i will try to describe it here
week1 2022 week1 2023 (in columns) week1 2022 week1 2023 week1 2022 week1 2023
clolumnA then column B then column c and make a dynamic slicer i am using pivot to make that slicer so i can see column A only if i want to see only Column A or others
Can you send it to me to see what the results are?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!