IMPROVED Dynamic [DAX] Analytics Lines in Power BI

Sdílet
Vložit
  • čas přidán 6. 08. 2024
  • Learn how to prevent a [DAX] error message when setting the Percentile percentage for the Dynamics Analytics Line I showcased back in October.
    RELATED CONTENT 🔗
    Dynamic [DAX] Analytics Line -- • Adding Dynamic [DAX] A...
    DAX Guide - PERTENTILE.EXC -- dax.guide/percentile-exc/
    DAX Guide - PERTENTILE.INC -- dax.guide/percentile-inc/
    BECOME A CHANNEL MEMBER 🎉
    -- / @havensconsulting
    LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
    -- / havensbi
    -- / reidhavens
    -- / havensconsulting
    VIDEO CHAPTERS 🎥
    0:00 - Start of Video
    0:06 - Content Intro
    HAVENS CONSULTING PAGES 📄
    Home Page - www.havensconsulting.net
    Blog -- www.havensconsulting.net/blog-...
    Blog Files -- www.havensconsulting.net/blog-...
    Files & Templates -- www.havensconsulting.net/files...
    Consulting Services -- www.havensconsulting.net/consu...
    Online Courses -- www.havensconsulting.net/onli...
    Contact & Support - www.havensconsulting.net/conta...
    EMAIL US AT 📧
    info@havensconsulting.net
    #PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #analyticsline
  • Věda a technologie

Komentáře • 8

  • @wayneedmondson1065
    @wayneedmondson1065 Před 2 lety

    Cool! Thanks for sharing this new information. Thumbs up!!

  • @adilmajeed8439
    @adilmajeed8439 Před 2 lety

    Is there a way to have a different color for the portion of the bar greater than the average value?

    • @HavensConsulting
      @HavensConsulting  Před 2 lety +1

      That's coming out in an upcoming video of mine :)

    • @adilmajeed8439
      @adilmajeed8439 Před 2 lety

      @@HavensConsulting looking forward for it anxiously

  • @lol-ki5pd
    @lol-ki5pd Před 2 lety

    Hi can you simply make a slice where I enter the value and and target line is created dynamically

    • @HavensConsulting
      @HavensConsulting  Před 2 lety +1

      You can! Use a WhatIf scenario slicer to have a slicer where you can input a value. Then use that DAX measure generated from the WhatIf slicer to go into the FX constant line option you see in this video.

    • @lol-ki5pd
      @lol-ki5pd Před 2 lety

      @@HavensConsulting thanks for the reply. I have requirment in my project where i need a input value and i can get a target line
      Can you make a small vedio on this? I know i am asking too much

    • @HavensConsulting
      @HavensConsulting  Před 2 lety

      @@lol-ki5pd here's a quick video showing how to do it. www.screencast.com/t/lKsTlljl5Wfh