topic Re: Dynamic Percent Change Over Two Dates in Slicer in DAX Commands and Tips

Dynamic Percent Change Over Two Dates in Slicer

pj0146 — Fri, 01 Nov 2024 20:50:25 GMT

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!

Re: Dynamic Percent Change Over Two Dates in Slicer

tharunkumarRTK — Sat, 02 Nov 2024 14:29:58 GMT

pj0146

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!

Re: Dynamic Percent Change Over Two Dates in Slicer

Anonymous — Wed, 06 Nov 2024 02:21:17 GMT

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.