Forum Discussion
Dynamic Percent Change Over Two Dates in Slicer
Hi everyone,
I am new to this forum and new to powerBI so I will try and state my problem as best as I can
I am looking for the right resource that will provide me a measure of percent change, but dependent on two slicer values(this is a sample of what the data looks like and spans over multiple months and years:
| January | 1000 |
| February | 1200 |
| March | 1500 |
| April | 1000 |
Slicer 1 = Start Month
Slicer 2 = End Month
Measure = Percent change over the selected months in both slicers
Any and all resources that can be provided would be greatly appreciated. Thank you!
Based on what I understand, since you want to give two slicers to your end users to select start and end months.
create two disconnected tables with Month column. In your slicers add those columns, You may need to keep the slicer as single select.
In your percentage change calculation, capture the selection of each slicer using selectedvalue function. Then pass the filter and calcualte the value of the respective start month and end month then you will be able to calculate the percentage difference.if you still need any further help then I would suggest you to share the PBIX file with sample data.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
2 Replies
- tharunkumarRTK
Super User
Based on what I understand, since you want to give two slicers to your end users to select start and end months.
create two disconnected tables with Month column. In your slicers add those columns, You may need to keep the slicer as single select.
In your percentage change calculation, capture the selection of each slicer using selectedvalue function. Then pass the filter and calcualte the value of the respective start month and end month then you will be able to calculate the percentage difference.if you still need any further help then I would suggest you to share the PBIX file with sample data.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Hi pj0146 ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster .
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
