Help with percentage

Question

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

tiger2514555 · Answer

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&nbsp;

mesumitdubey · Answer

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&nbsp; i need like this i will try to describe it hereweek1 2022 week1 2023 (in columns)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;week1 2022 week1 2023&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;week1 2022 week1 2023clolumnA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;then column B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; then column c&nbsp; 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