Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
73 | |
56 | |
38 | |
31 |
User | Count |
---|---|
84 | |
63 | |
63 | |
49 | |
45 |