Forum Discussion
Change Report Values Based on Slicer
I have a report with a large set of data, including one that tells me how many hours each of my machines were being used. In Dax, I then calculated the (hours used per day / 24 hours), to see what percentage of the day the machine has been used for.
I would now like a slicer on my report that lets me toggle the 24 hour value between 24 hours, 8 hours, and 16 hours, so I can see the utilization based on different shifts. How do I dynamically caluclate this value, using a slicer? I would like to do this without power query if possible.
Thank you!
emmawdmi22
Here is a link to download a sample solution file:
Change Report Values Based on Slicer 2022-08-02.pbix
1 Reply
- SpartaBI
Community Champion
emmawdmi22
Here is a link to download a sample solution file:
Change Report Values Based on Slicer 2022-08-02.pbix