Forum Discussion
Dynamic Percent Change Over Two Dates in Slicer
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.