Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
mesumitdubey
New Member

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 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 advanceWhatsApp Image 2023-11-17 at 08.43.36.jpegWhatsApp Image 2023-11-17 at 08.43.37.jpeg
@GuyInACube @amitchandak  @NotGregDeckler @Tiger2514555 

4 REPLIES 4
mesumitdubey
New Member

@Ritaf1983  could you check if you can help me out with this issue

 
Tiger2514555
Helper III
Helper III

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

Tiger2514555_0-1700194677385.png

 

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?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.