Driven BI Data
Driven BI Data
  • Видео 42
  • Просмотров 80 875
Dynamically Switch Data source (Excel to SQL) with Power Query Parameters | Power BI Tutorials
Learn how to switch between Excel and SQL using Power Query parameters! This step-by-step tutorial will help you simplify your workflow and making sheet switching more efficient.
Music Credits:
"Scott Buckley - Snowfall" is under a Creative Commons (BY 3.0) license:
creativecommons.org/licenses/by/3.0/
ruclips.net/user/musicbyscottb
Music powered by BreakingCopyright: ruclips.net/video/htAlfvjQrQU/видео.html
#powerbitutorial #drivenbidata #powerbicharts #powerbitips #powerquery #powerquerytutorial #ExcelTips #PowerQuery #DataAutomation #ExcelTricks #DynamicSheets #businessintelligence
Просмотров: 217

Видео

Short Month Names using DAX | Power BI Tutorial
Просмотров 655Месяц назад
In this video, I demonstrate how to efficiently shorten month names (e.g., January, February, March) to their abbreviated forms (J, F, M) in Power BI. This quick tip will help you customize your reports with cleaner, more compact month labels using UNICHAR. Whether you're working with date data or optimizing visual space, this trick can enhance your Power BI dashboards. PBIX file: github.com/Su...
Scroller Visual in Power BI using SVG | Native Visual | SVG Animation
Просмотров 1,4 тыс.2 месяца назад
In this video, learn how to create Scroller visual using simple SVG animations. Blog: drivenbidata.wordpress.com/2024/11/11/scroller-visual-in-power-bi-using-svg/ Music Credits: "Scott Buckley - Snowfall" is under a Creative Commons (BY 3.0) license: creativecommons.org/licenses/by/3.0/ ruclips.net/user/musicbyscottb Music powered by BreakingCopyright: ruclips.net/video/htAlfvjQrQU/видео.html #...
Dynamic Sheet Switching with Power Query Parameters | Power BI Tutorial
Просмотров 7743 месяца назад
Learn how to switch between different sheets dynamically using Power Query parameters! This step-by-step tutorial will help you simplify your workflow and making sheet switching more efficient. #powerbitutorial #drivenbidata #powerbicharts #powerbitips #powerquery #powerquerytutorial #ExcelTips #PowerQuery #DataAutomation #ExcelTricks #DynamicSheets #businessintelligence
SVG Blink Animation | Highlights/Alerts in Power BI
Просмотров 6 тыс.4 месяца назад
In this video, learn how to highlight critical alerts using simple SVG blink animations. We'll show you step-by-step how to add blinking effects to draw attention to important alerts in your projects. Music Credits: "Scott Buckley - Snowfall" is under a Creative Commons (BY 3.0) license: creativecommons.org/licenses/by/3.0/ ruclips.net/user/musicbyscottb Music powered by BreakingCopyright: rucl...
Dynamic Patterns for SVG Bars | Power BI
Просмотров 1,5 тыс.4 месяца назад
In this Power BI tutorial, you'll learn how to create dynamic SVG bar charts with custom patterns like crosshatch, diamond, and dotted fill by embedding SVG code. SVG Bar Part 1: ruclips.net/video/BT26Gd5bWEY/видео.html Music Credits : ruclips.net/video/H4BAEf5V-Yc/видео.html #SVG #BarChart #DataVisualization #WebDevelopment #Charts #CodingTutorial #DataViz #ResponsiveDesign #PowerBI #DataAnaly...
SVG Bar Charts in Power BI
Просмотров 3,7 тыс.4 месяца назад
In this video, we dive into SVG bar chart variations, showcasing different styles and techniques to enhance your data visualizations. Learn how to create dynamic, responsive, and visually appealing bar charts using Scalable Vector Graphics (SVG). Music Credit: ruclips.net/video/H4BAEf5V-Yc/видео.html #SVG #BarChart #DataVisualization #WebDevelopment #Charts #CodingTutorial #DataViz #ResponsiveD...
Custom Shape Map in Power BI | Power BI Tutorial
Просмотров 4,5 тыс.4 месяца назад
In this tutorial, we'll walk you through the process of using custom shape maps in Power BI to enhance your data visualizations. Blog: drivenbidata.wordpress.com/2024/09/16/custom-shape-maps-in-power-bi/ #PowerBI #CustomMaps #ShapeMap #DataVisualization #GeographicData #BusinessIntelligence #DataAnalysis #PowerBITutorial #MapVisualization #CustomShapes #DataReporting #PowerBIMaps #Analytics #dr...
Highlight Min/Max Values Across Multiple Years | Power BI Tutorial
Просмотров 1,7 тыс.4 месяца назад
In this video, learn how to highlight the minimum and maximum values across multiple years in Power BI. Whether you're visualizing sales data, financial trends, or performance metrics, this step-by-step guide will show you how to dynamically emphasize key data points in your reports. With these techniques, you’ll make your dashboards more insightful and easier to understand at a glance. Part 1 ...
Build an Interactive Sales Dashboard in Power BI
Просмотров 3,3 тыс.5 месяцев назад
In this video, we will show you how to create an interactive sales dashboard using Power BI. You’ll learn how to track your sales, profits, and more with easy-to-use visuals and reports. Dataset: github.com/SunoMath/Power_Bi/tree/main/Datasets Music: ruclips.net/video/H4BAEf5V-Yc/видео.htmlsi=fvHwPwG9gT8qv3kT #PowerBI #SalesDashboard #DashboardTutorial #PowerBI #DataVisualization #BusinessIntel...
Arrow Charts in Power BI | Visualize Growth & Decline with Error Bars | Power BI Tutorial
Просмотров 1,5 тыс.5 месяцев назад
Learn how to create arrow charts in Power BI to visualize growth and decline using error bars. This tutorial covers step-by-step customization, color-coding for trends, and formatting for making your charts stand out. PBIX: github.com/SunoMath/Power_Bi/tree/main/Arrow Chart Blog: drivenbidata.wordpress.com/2024/08/29/creating-an-arrow-chart-in-power-bi/ Music: ruclips.net/video/H4BAEf5V-Yc/виде...
Dynamic Top N & Bottom N with proper Sorting using RANKX
Просмотров 8585 месяцев назад
In this video, you'll learn how to dynamically switch between Top N and Bottom N rankings in Power BI using DAX and properly sort using the RANKX function. Checkout our Blogpost for a detailed description of the video. drivenbidata.wordpress.com/2024/08/18/top-bottom-with-dynamic-sorting-in-power-bi PBIX File: github.com/SunoMath/Power_Bi/tree/main/Dynamic Sorting #PowerBI #RANKX #TopN #BottomN...
Import Local Images into Power BI | Power BI Tutorial
Просмотров 7445 месяцев назад
In this video, I'll guide you through two powerful methods for importing local images into Power BI. We'll explore the use of online image encoding to convert your images into bas64, and we'll dive into the Binary.ToText M function within Power Query for an advanced approach. Online Encoder: www.base64-image.de/ Blog: drivenbidata.wordpress.com/2024/08/17/importing-local-images-into-power-bi-us...
Show Top N with 'Others' in Your Visuals | Power BI Tutorial
Просмотров 9495 месяцев назад
Learn how to display the Top N items in Power BI while grouping the rest under 'Others.' Perfect for dashboards and reports that need to focus on the most important elements without losing context of the overall data distribution. This step-by-step tutorial will guide you through setting up dynamic visuals that provide a clear and concise representation of your data. PBIX file: github.com/SunoM...
Gradient Donut in Power BI using SVG | Native Visual
Просмотров 6 тыс.6 месяцев назад
In this video, learn how to create a stunning gradient donut chart in Power BI using SVG (Scalable Vector Graphics). This technique will help you elevate your data visualizations and make your reports stand out. Read this as blog: drivenbidata.wordpress.com/2024/08/03/svg-gradient-donut/ PBIX file & SVG Code: github.com/SunoMath/Power_Bi/tree/main/SVG Gradient Donut #gradientdonut #svgicon #SVG...
Dynamic SVG icon using table visual | Native visual | Power BI Tutorial
Просмотров 2,1 тыс.7 месяцев назад
Dynamic SVG icon using table visual | Native visual | Power BI Tutorial
Dynamic TopN Ranking with Parameters | TopN with "All" | Power BI Tutorial
Просмотров 2,6 тыс.8 месяцев назад
Dynamic TopN Ranking with Parameters | TopN with "All" | Power BI Tutorial
Variance Arrow in a Column/Bar Chart | Power BI Tutorials
Просмотров 6 тыс.10 месяцев назад
Variance Arrow in a Column/Bar Chart | Power BI Tutorials
Horizontal Lollipop Chart using Native Bar Chart | Power BI Tutorials | Power Bi Core Visual
Просмотров 2,5 тыс.10 месяцев назад
Horizontal Lollipop Chart using Native Bar Chart | Power BI Tutorials | Power Bi Core Visual
Power Bi Beginners Dashboard | Get Started with Power BI
Просмотров 72411 месяцев назад
Power Bi Beginners Dashboard | Get Started with Power BI
Calendar table using Power Query with Static and Dynamic End date | Power BI
Просмотров 967Год назад
Calendar table using Power Query with Static and Dynamic End date | Power BI
Calendar Heatmap using Matrix Visual | Power Bi
Просмотров 6 тыс.Год назад
Calendar Heatmap using Matrix Visual | Power Bi
Dynamic Targets in Power Bi Column Chart
Просмотров 3,5 тыс.Год назад
Dynamic Targets in Power Bi Column Chart
Beyond Bar Charts: Creating Lollipop Visual in Power BI
Просмотров 2,8 тыс.Год назад
Beyond Bar Charts: Creating Lollipop Visual in Power BI
Highlight Max & Min Values in Power Bi Column Chart
Просмотров 5 тыс.Год назад
Highlight Max & Min Values in Power Bi Column Chart
How to Create 📆 Calendar Table/Date Table using DAX in Power BI
Просмотров 1 тыс.Год назад
How to Create 📆 Calendar Table/Date Table using DAX in Power BI
Highlighting Line Chart Markers in Power Bi
Просмотров 12 тыс.2 года назад
Highlighting Line Chart Markers in Power Bi
Mini Charts in Excel - Sparklines
Просмотров 1272 года назад
Mini Charts in Excel - Sparklines
Choosing the Right Text Function: CONCATENATE vs CONCAT vs TEXTJOIN in Excel
Просмотров 3382 года назад
Choosing the Right Text Function: CONCATENATE vs CONCAT vs TEXTJOIN in Excel
Excel Date Function | NOW() vs TODAY()
Просмотров 442 года назад
Excel Date Function | NOW() vs TODAY()

Комментарии

  • @VagnerSimango-s6u
    @VagnerSimango-s6u 6 дней назад

    Muito mau, valeu

  • @slvenom1
    @slvenom1 8 дней назад

    in my company report server verison no shape map,sad

  • @WilantaraOngky
    @WilantaraOngky 21 день назад

    I've tried it, and there are no errors, but the screen is blank, and no image is showing. Can you help me with that?

  • @Back1Ply
    @Back1Ply 29 дней назад

    You can also do it in power query // Added Month Name S (Special formatting for Month name) #"Added Month Name S" = Table.AddColumn(#"Inserted Year Quarter", "Month Name S", each Text.Repeat(Character.FromNumber(8203), 12 - Date.Month([Date])) & Text.Start(Date.MonthName([Date]), 1), type text)

  • @ashwaniaggarwal4218
    @ashwaniaggarwal4218 Месяц назад

    please share the svg. Thanks. it looks amazing.

  • @GajendraTodkar
    @GajendraTodkar Месяц назад

    Can you share dataset for this.

  • @Srinivas_13
    @Srinivas_13 Месяц назад

    Indeed, iterations each time, Just extract first letter from month name column at power queryside which is more performance...... Try, this works

    • @drivenBIdata
      @drivenBIdata Месяц назад

      Tried with Power Query and it works! Thanks for the comment. Here is the code to create "Custom Column" let MonthNumber = Date.Month([Date]), MonthInitial = Text.Start(Date.ToText([Date], "MMM"), 1), ZeroWidthSpace = Character.FromNumber(8203), UniqueInitial = MonthInitial & Text.Repeat(ZeroWidthSpace, MonthNumber) in UniqueInitial

  • @zahir585
    @zahir585 Месяц назад

    Brilliant thx for sharing

  • @djaleleddineboussahel1501
    @djaleleddineboussahel1501 Месяц назад

    Good idea thanks

  • @itikshamittal
    @itikshamittal Месяц назад

    Nice visual 🎉

  • @zahir585
    @zahir585 Месяц назад

    Brilliant thx for sharing ♥️

  • @cmcc4190
    @cmcc4190 Месяц назад

    Thanks very much - great video

  • @DiegoVelazquez-rf4nj
    @DiegoVelazquez-rf4nj Месяц назад

    thank you! it saved me more than 250 usd a year <3

  • @Nikxy22
    @Nikxy22 Месяц назад

    what is the canvas size?

  • @kummithavenkatareddy2302
    @kummithavenkatareddy2302 Месяц назад

    Thanks a lot Bro

  • @sebastianpulido345
    @sebastianpulido345 2 месяца назад

    WOW Amazing crack I would like to know how you remove the white background and make it transparent, is it possible?

  • @shubhabratadey
    @shubhabratadey 2 месяца назад

    Thanks for sharing. The issue I am facing is whenever I am adding these visuals on my table, the row heights are increasing automatically even though the symbols are smaller in size. I am not been able to address that. If I try to reduce the size of the circle then the size looks like a dot. If anyone here has the fix kindly share

  • @harshalpalande1796
    @harshalpalande1796 2 месяца назад

    @drivenBIdata, The read me file has no data. Can you please share it again?

    • @drivenBIdata
      @drivenBIdata 2 месяца назад

      You will find two files in the below folder github.com/SunoMath/Power_Bi/tree/main/Datasets 1. Readme file 2. Sport Products Sales Analysis.xlsx (dataset)

    • @harshalpalande1796
      @harshalpalande1796 2 месяца назад

      Can you please share the file?

  • @katepopo-ola265
    @katepopo-ola265 2 месяца назад

    This is brilliant, thank you.

  • @debashishbasu1505
    @debashishbasu1505 2 месяца назад

    Picture not showing

  • @Muhyd33n
    @Muhyd33n 2 месяца назад

    The Measure is well formatted and clear. Thanks

  • @emersongaldino7366
    @emersongaldino7366 2 месяца назад

    NIIIIICEEEEEE

  • @logocreative1694
    @logocreative1694 2 месяца назад

    Can we apply condition formatting in dot

  • @manojkumarejjada
    @manojkumarejjada 2 месяца назад

    Excellent 👏

  • @sadiqabkr
    @sadiqabkr 2 месяца назад

    Great 👍 work. Thanks

  • @Littlenglish
    @Littlenglish 2 месяца назад

    cool

  • @Nasaka_Watitwa
    @Nasaka_Watitwa 2 месяца назад

    This is so good. Thank you.

    • @drivenBIdata
      @drivenBIdata 2 месяца назад

      Thank you.. Glad you found this useful.

  • @crazycool52
    @crazycool52 2 месяца назад

    is it possible to show the regions as well within each emirate?

  • @TriNguyen-mr9tt
    @TriNguyen-mr9tt 2 месяца назад

    This is fantastic. Would you consider creating 100% stacked horizontal bar chart using svg?

  • @Lokenathofficial
    @Lokenathofficial 2 месяца назад

    Wonderful Video !! just wondering when i am trying to use the day name the dayname is not sorted like Sunday,Monday.... instead Friday, Monday.... , tried to use a table with sort order and made relationship with date table but still failed .....

  • @swapnil010283
    @swapnil010283 3 месяца назад

    This is simply outstanding work ! The solution is practical, needed at multiple places, and not natively available in PowerBI.

  • @nishantkumar9570
    @nishantkumar9570 3 месяца назад

    Awesome! Thanks for sharing such a neat process. Additionally, I really loved the music. You are awesome! Keep sharing more stuffs. Thank so much.

    • @drivenBIdata
      @drivenBIdata 2 месяца назад

      Thank you for your kind words Nishant! Glad you found this content useful.

  • @guillermoluscher7829
    @guillermoluscher7829 3 месяца назад

    Excellent work. Congrats! Likewise, when I place the measure in the table, it copies the measure code to the cell. It doesn't give me the desired result. Please, can u share the svg ?

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      Thank you! To display the SVG, make sure to set the measure's data category to Image URL in the Measure tools tab. If this isn’t done, you’ll see the SVG code instead of the visual itself.

    • @guillermoluscher7829
      @guillermoluscher7829 3 месяца назад

      @@drivenBIdata 🙌💪

  • @paulgallagher2987
    @paulgallagher2987 3 месяца назад

    Love this. Very elegant solution.

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      Thank you! Glad you like it! ✨️

  • @wygoda123
    @wygoda123 3 месяца назад

    absolute gamechanger. I have not seen anything so good for quite a while.

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      Glad you enjoyed it! We truly appreciate your support.

  • @AK-ij9il
    @AK-ij9il 3 месяца назад

    Hi Brother , API Data Source Power BI il use cheyyaan limitation undo? Njn oru 3lakh rows table (10k rows on each API call) il retrieve chythu, 10k rows 30 set aayt. Athine pinne append cheyyan nokyt success aavnnla... API Data Source nte limitation aavuo API Data Source il work chythndnkl ith resolve idea undnkl parayavo?

  • @AlejandraLemmo
    @AlejandraLemmo 3 месяца назад

    Hello, Thank you for sharing. A question, the SVG image takes up a lot of space in the row, not the rectangle but the image itself. How to fix it? Thanks

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      Hello, happy to share. For the best fit, you can try resizing the image height and width in the visual pane. You may also have to check the viewBox dimensions. The width or height of the viewBox should match or exceed the dimensions of the largest shape or text to prevent any clipping.

    • @AlejandraLemmo
      @AlejandraLemmo 3 месяца назад

      @@drivenBIdata thanks!!

  • @eliash7921
    @eliash7921 3 месяца назад

    I couldn’t find the map of Sweden on simple maps…

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      Please check out our blog in the description for the country code. You'll find a detailed walkthrough there.

  • @iamanatoliy
    @iamanatoliy 3 месяца назад

    Please, can u share the svg ?

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      You can find all the files here -> github.com/SunoMath/Power_Bi/tree/main/SVG%20Blink%20Animation

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      You can find all the files here -> github.com/SunoMath/Power_Bi/tree/main/SVG%20Blink%20Animation

  • @srinupampana3814
    @srinupampana3814 3 месяца назад

    Amazing, Learned new thing today!🎉

  • @iamanatoliy
    @iamanatoliy 3 месяца назад

    👍👍👍

  • @XITIJTHOOL
    @XITIJTHOOL 3 месяца назад

    😊

  • @xL0NeLYx
    @xL0NeLYx 3 месяца назад

    is there a way to show the population on the map itself? in your example whenever you hover over a city it shows the number. Is it possible to show the number without hovering as if it was a data label?

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      That's an excellent question. Something we tried to work on as well. Unfortunately, we don't have an option for that. But we will update you here if we find any workaround in the future.

    • @MajidFalehx2010xMMM
      @MajidFalehx2010xMMM Месяц назад

      You can create a card visual

  • @AK-ij9il
    @AK-ij9il 3 месяца назад

    Power BI API Data source oru video cheyyamo? API through data collect chyth data source aayi use cheyth report automate cheyyan

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      We will definitely look into this and upload a video soon.

    • @AK-ij9il
      @AK-ij9il 3 месяца назад

      @@drivenBIdata Bro, API via Datasource use chyth work chythtndo?

  • @petenyu8850
    @petenyu8850 3 месяца назад

    Found a problem with svg files not convert to images

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      Do you mean when you export it as a table? When exported as table it will be converted to the code structure. If you are referring to something else, please do let me know.

  • @sofianeboukecha
    @sofianeboukecha 4 месяца назад

    great work, can you, please, share with us the code?

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      Thank you.. You can find the code and PBIX file here -> github.com/SunoMath/Power_Bi/tree/main/SVG%20Blink%20Animation

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      You can find all the files here -> github.com/SunoMath/Power_Bi/tree/main/SVG%20Blink%20Animation

  • @mirrrvelll5164
    @mirrrvelll5164 4 месяца назад

    Awesome!

  • @RobsonRodrigo-o6i
    @RobsonRodrigo-o6i 4 месяца назад

    A-MA-ZING 🤩

  • @mirrrvelll5164
    @mirrrvelll5164 4 месяца назад

    This is great. So that means I can do this similarly on all pics`?

    • @drivenBIdata
      @drivenBIdata 4 месяца назад

      Absolutely! The same can be done with any SVG image.

  • @sohailansari9337
    @sohailansari9337 4 месяца назад

    Awesome where can I download the PBI file?. Thanks

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      You can find the PBIX file here -> github.com/SunoMath/Power_Bi/tree/main/SVG%20Blink%20Animation

    • @drivenBIdata
      @drivenBIdata 3 месяца назад

      You can find all the files here -> github.com/SunoMath/Power_Bi/tree/main/SVG%20Blink%20Animation