Creating a Dynamic Measure in Power Bi

Hi all,

Have you ever wondered if you can dynamically select a value to appear in your DAX measures? Can I change my graph from showing total distance to high-speed running distance?

You sure can, and in this Power Bi For Sport video I am going to show you how.

Using a little DAX trick with the SWITCH function and a dropdown slicer, you can create a simple selector to choose your metric to view. That metric can then be added to your calculations in the graph, allowing you to quickly change between metrics of choice. You can watch the video below or head over to YouTube!

What are you going to use this trick for? Let me know in the comments below.

As always, subscribe here for more videos and to help you Power Performance Through Data.



Enjoy the video and if you have any questions, please leave a comment below.


comments powered by Disqus