Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello,
I currently have two date tables. One is .Date and the other is .Compare Date. Each are created by the function:
Previous Period MAX = (MAX('.Date'[Date]) - 1) - [Selected Dates]
Previous Period MIN = (MIN('.Date'[Date]) - 1) - [Selected Dates]
Previous Year MAX = (MAX('.Date'[Date]) -365)
Previous Year MIN = (MIN('.Date'[Date]) -365)
Selected Dates = DATEDIFF(MIN('.Date'[Date]), MAX('.Date'[Date]), DAY)
from what i understand, and correct me if im wrong, you need to have a slicer with the following values :
and base on the selection , it will change the measure in the visual respecting the selecteed value .
if this is what youu want ,
you can use field paramters feature to achieve it .
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
HI @jn123 ,
If i understand correctly, i would still believe that if using measure and using proper DAX calculation which considers previous period, values from compare table can be calculated. I dont see use case for second slicer. if you do not want to allow user to select anything from the sliver
But neverthless if you want to have possibility to add it on slicer, we can check with experts in the community
Thanks and Regards,
Sayali
Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!
Proud to be a Super User!
Hi @jn123 ,
Unfortunately i am not aware how to create dynamic slicer for compare dates.
I'm having difficulty understanding the specific purpose of providing a Compare Date slicer to the user.
I was wondering if it would be possible to achieve the desired outcome by creating direct measures that calculate for the previous period or year?
Thanks and Regards,
Sayali
Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!
Proud to be a Super User!
@sayaliredij The goal is for the end user to be able to see for example, total sales for "this" month (filtered by the .Date table) and then be able to see the percent difference of the sales "this month" vs the "previous month" or the same period in the previous year. The percent difference calculation is based on the dates in the .Compare table so I need to be able to filter the .Compare dates based on what is selected on the .Date table.
Thanks,
User | Count |
---|---|
90 | |
88 | |
86 | |
79 | |
49 |
User | Count |
---|---|
151 | |
143 | |
111 | |
74 | |
55 |