Forum Discussion

mesumitdubey's avatar
mesumitdubey
New Member
2 years ago

Help with percentage

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...
Need Help
Tiger2514555's avatar
Tiger2514555
Icon for Helper III rankHelper III
2 years ago

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

 

mesumitdubey's avatar
mesumitdubey
New Member
2 years ago

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

  • Tiger2514555's avatar
    Tiger2514555
    Icon for Helper III rankHelper III
    2 years ago

    Can you send it to me to see what the results are?