Forum Discussion

clachi80's avatar
clachi80
Frequent Visitor
6 years ago

Use slicer selection in a function

I have created two slicers both listing all hours in a day populated from two tables with one column The user must select one hour in each slicer: one indicating the starting hour and one the ending...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

You could make two What If Parameters from 1-24 (hours); see the Modeling tab.  That will make two new tables and add slicers to the report.  There will also be measures created to harvest the selected values.  You can then add a variable to your measure that calculates the difference between those two whatif measures.

 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

I've also created two tables through the What if parameter and added a measure with a variable that returns the time difference between the two hours selected in the two slicers... and it worked, I'm able to see the correct value on a card

My problem is that I don't know how (and if possible) to use this value in a function in a computed column like the one indicated in my post. How can I use my VAR in this function instead of the number 10?