Apply a DYNAMIC FILTER to your report with the PLAY AXIS | Report Animation in Power BI

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 ก.ค. 2024
  • Inspired by the thousands of US election maps I show you how to apply a dynamic filter to your report with a cool feature that stood out - the Play Axis Visual. It lets you automatically change the filter selection and you can decide how quickly and if it should run in a loop. Try this animation on your report and let me know what you think. Enjoy!
    Download file here datatraining.io/powerbi-how-to
    --------------------------------
    📊 TRAININGS 📊
    ---------------------------------
    Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
    Power BI Essentials datatraining.io/powerbilearni...
    Business User Training datatraining.io/powerbi-busin...
    For Custom Trainings and Consulting email directly support@datatraining.io
    ---------------------------------
    ⏱️ TIMESTAMPS ⏱️
    ---------------------------------
    0:00 Intro
    0:41 Creating the multi card visuals
    4:40 Creating the map visual
    5:28 Adding a Play Axis
    8:10 Showing the filter selection
    10:04 Using the play axis on a scatter plot
    13:00 End
    ---------------------------------
    😍 JOIN 😍
    ----------------------------------
    Join bit.ly/4b453bi
    Subscribe bit.ly/31MnQGO​
    Insta / howtopowerbi
    LinkedIn / basdohmen
    TikTok / how.to.power.bi
    X / howtopowerbi
    fb / howtopowerbi
    Threads www.threads.net/@howtopowerbi
    Newsletter datatraining.io/newsletter
    ---------------------------------
    👇 CHECK THIS OUT! 👇
    ---------------------------------
    💻 My gear amzn.to/47F21Yc
    📚 Power BI books MUST READ! amzn.to/3tUfFcj
    💡 General books I recommend amzn.to/48YNo33
    🎶 Music for my videos www.epidemicsound.com/referra...
    🚀 For growing on TH-cam: www.tubebuddy.com/bas
    🏄 Stuff I use daily amzn.to/3HqfMQ2
    * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
    Thanks for being a part of this channel and all your support! 💪 🙏
    #HowToPowerBI​ #PowerBI​ #DataTraining​
    #powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 21

  • @UPerfil1
    @UPerfil1 ปีที่แล้ว

    Congratulations, thank you very much.

  • @alexkim7270
    @alexkim7270 3 ปีที่แล้ว +2

    Whoa dude! I never knew there's the alignment feature in Power BI! I was just thinking about it recently, "Can't arranging be easy as PowerPoint?"
    Then your video popped up.

    • @HowtoPowerBI
      @HowtoPowerBI  3 ปีที่แล้ว +2

      😀 haha your life will never be the same again 😉

    • @spen2431
      @spen2431 3 ปีที่แล้ว +1

      @@HowtoPowerBI The "Format Painter" was a game changer for me 😀

  • @xinranji775
    @xinranji775 ปีที่แล้ว

    Great video. Just one question, if I am doing a real-time big screen dashboard using Power BI connecting to SQL Server and want the data to be refreshed every second, can I accomplish this using Play Axis?

  • @sixtyfiveroses2968
    @sixtyfiveroses2968 2 ปีที่แล้ว

    Great video. Thank you!

  • @StephanOnisick
    @StephanOnisick 2 ปีที่แล้ว +1

    Awesome Demo! Love it!

    • @HowtoPowerBI
      @HowtoPowerBI  2 ปีที่แล้ว

      Thanks Stephan, much appreciated :)

  • @gambu4810
    @gambu4810 2 ปีที่แล้ว

    I'm getting overwhelmed with brilliance! You are absolutely brilliant!!! A true Leonel Messi of Power BI. Bra I really wish to know you personally. I'll check your LinkedIn.

    • @HowtoPowerBI
      @HowtoPowerBI  2 ปีที่แล้ว +2

      Messi?! I was hoping lewandowski 😋 haha thx Gambu!!!

    • @gambu4810
      @gambu4810 2 ปีที่แล้ว

      @@HowtoPowerBI Hahaha. You're a GOAT!

  • @how2593
    @how2593 ปีที่แล้ว

    Hi please help, how can I create a loop with PLAY AXIS to filter between all time and only today data. It would be like if I had a slicer with "select all" and "today" option but with Play Axis! I tried but one condition exclude the other.

  • @vinodtpba
    @vinodtpba ปีที่แล้ว

    Is there a visual to automatically scroll down a table automatically. Eg. If there are 10 items listed, only 4 can be viewed based on the preset size of the visual, the table view should automatically scroll down to display all the items.

  • @markjaypee
    @markjaypee 9 หลายเดือนก่อน

    Would it be possible for Play Axis to show cumulative data, instead of data per year?

  • @totvabe1
    @totvabe1 3 ปีที่แล้ว +3

    I was wondering if it would be possible to run the play axis over a parameter different from the time. And then show how the rest of variables evolve.

  • @dcpowered
    @dcpowered 2 ปีที่แล้ว

    Hey Bas, thanks a lot for all your great videos! Is it possible to automate export of a PBI report to pdf for all pages based on all slicer values?

    • @vazik_cze
      @vazik_cze 2 ปีที่แล้ว

      try Power BI Robots

  • @lilpinkiy
    @lilpinkiy 3 ปีที่แล้ว +3

    Sorry if a stupid question but for the data how do did you get the data on the hour every hour? Was it a script or is the data saved on the website? Great video as always!

    • @HowtoPowerBI
      @HowtoPowerBI  3 ปีที่แล้ว

      For the video I simply downloaded the csv file and then in Power Query took one value for each hour. I believe there is a API though for the data.