Month: February 2023

How to get a CLOCK in your Power BI Report

Posted on by Annie D

We had a question about how to get a clock in Power BI? Is that even possible? Patrick takes advantage of the Deneb visual to make it happen!

Vega Clock Sample
https://vega.github.io/vega/examples/clock/

HTML Content Custom Visual Limitations
https://www.html-content.com/reference/limitations

Kerry Kolosko
https://kerrykolosko.com/exploring-deneb-for-power-bi/

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— <a Continue reading “How to get a CLOCK in your Power BI Report” →

Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_

Posted on by Annie D

Free Classes & Videos on the home page of my excelisfun channel: https://www.youtube.com/@excelisfun
This video introduces you to the excelisfun channel at YouTube, where you can learn anything would want about Excel and Power BI. My name is Mike Girvin. I am a professor at Highline College and a Microsoft Excel MVP since 2013. I have posted over 3,500 videos and created over 100 playlist of videos since Feb 2008 here at YouTube. The Home page: youtuve.com/@excelisfun , has full free classes in: 1) Microsoft 365 Excel/Power BI, 2) Basic and Advanced Excel, 3) Basics and Advanced Data Continue reading “Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_” →

What’s New & What’s Coming For Power BI | Innovations In Power BI & Power Platform Summit Session 14

Posted on by Annie D

Session 14: What’s New & What’s Coming For Power BI

When is it?
February 22nd – 10am Los Angeles (PST), 1pm New York (EST), 6pm London (GMT)
February 23rd – 5am Sydney (AEDT), 7am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Jay ter Heerdt – Microsoft, Senior Program Manager for Power BI

During This Free Event, You Will:

• Learn how the improved user experience in Power BI has made it easier to create and manage complex calculations
• Discover new and enhanced visualization options, improved collaboration Continue reading “What’s New & What’s Coming For Power BI | Innovations In Power BI & Power Platform Summit Session 14” →

Collection Of Custom Visuals & Niche Techniques In Power BI

Posted on by Annie D

Session 16: Collection Of Custom Visuals & Niche Techniques In Power BI

When is it?
February 23rd – 12am Los Angeles (PST), 3am New York (EST), 8am London (GMT), 7pm Sydney (AEDT), 9pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Injae Park – Senior Business Intelligence Developer, Objectivity

During This Free Event, You Will:

• Embed HTML, CSS, and JavaScript code directly into your report using HTML visuals
• Explore a wide range of options for customizing the appearance of your data visualizations with 1400+ Fonts Continue reading “Collection Of Custom Visuals & Niche Techniques In Power BI” →

5 Report Design Tricks That Will Make Any Power BI Report Look Awesome

Posted on by Annie D

Session 12: 5 Report Design Tricks That Will Make Any Power BI Report Look Awesome

When is it?
February 22nd – 8am Los Angeles (PST), 11am New York (EST), 4pm London (GMT)
February 23rd – 3am Sydney (AEDT), 5am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Mara Periera – Founder & Principal Power BI Architect, Data Pears

During This Free Event, You Will:

• Understand the main factors that can influence the design and user experience of your Power BI reports
• Learn how Data Visualization techniques Continue reading “5 Report Design Tricks That Will Make Any Power BI Report Look Awesome” →

Methods Of Improving UX & Data Storytelling Through Combination Of Design Components & DAX

Posted on by Annie D

Session 11: Methods Of Improving UX & Data Storytelling Through Combination Of Design Components & DAX

When is it?
February 22nd – 7am Los Angeles (PST), 10am New York (EST), 3pm London (GMT)
February 23rd – 2am Sydney (AEDT), 4am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Gustaw Dudek – Enterprise DNA Expert

During This Free Event, You Will:

• Implement selected design techniques and chat formatting options to enhance overall user experience (UX)
• Choose strategic DAX applications to effectively communicate data insights through compelling data storytelling

If Continue reading “Methods Of Improving UX & Data Storytelling Through Combination Of Design Components & DAX” →

Excel Replace Is Breaking VLOOKUP – 2379

Posted on by Annie D

Rich needs to VLOOKUP into data with ” Total” after the tracking number.

When he tries to Replace ” Total” with “”, Excel converts the tracking numbers to scientific notation. When he tries to convert everything to numbers and I lose the last several digits when they change to 0000.

In today’s video, a new option in Microsoft 365 beta to prevent the conversion to scientific notation. And then a way to hack the VLOOKUP formula.

Table of Contents
(0:00) Copy subtotals in Excel
(0:36) Replace in Excel converts to Scientific Notation
(0:54) Long numbers in Excel last digits change to zero
(1:09) Beta option Continue reading “Excel Replace Is Breaking VLOOKUP – 2379” →

The A to Z Of Data Visualization | Innovations In Power BI & Power Platform Summit Session 9

Posted on by Annie D

Session 9: The A to Z Of Data Visualization

When is it?
February 22nd – 4am Los Angeles (PST), 7am New York (EST), 12pm London (GMT), 11pm Sydney (AEDT)
February 23rd – 1am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Juan-Pierre Louw – Microsoft Power Platform & Data Visualization Enthusiast

During This Free Event, You Will:

• The A to Z framework provides a step-by-step approach for beginners to implement data visualization effectively
• Enhance Power BI Visualization with easy techniques
• Get a clear understanding of the data that Continue reading “The A to Z Of Data Visualization | Innovations In Power BI & Power Platform Summit Session 9” →

Increase The Adoption Of Reports w/ Dynamic Commenting

Posted on by Annie D

Session 8: Increase The Adoption Of Reports w/ Dynamic Commenting

When is it?
February 22nd – 3am Los Angeles (PST), 6am New York (EST), 11am London (GMT), 10pm Sydney (AEDT)
February 23rd – 12am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Wilco Nagtzaam & Pieter Jan de Vries, KPN

During This Free Event, You Will:

• Learn to integrate a Power App with Power BI to create a user-friendly dynamic commenting system for your reports
• Allow real-time collaboration and commenting on reports and enable users to add, Continue reading “Increase The Adoption Of Reports w/ Dynamic Commenting” →

Bring Spatial Insight To Your Data By Combining It w/ 3D Models In Power BI

Posted on by Annie D

Session 10: Bring Spatial Insight To Your Data By Combining It w/ 3D Models In Power BI

When is it?
February 22nd – 5am Los Angeles (PST), 8am New York (EST), 1pm London (GMT)
February 23rd – 12am Sydney (AEDT), 2am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Kenny Geyskens – Creator of 3DBI, The 3D Visual For Power BI

During This Free Event, You Will:

• Create 3D models suitable for visualizing them in the custom 3DBI visual for Power BI
• Bring derived data from 3D Continue reading “Bring Spatial Insight To Your Data By Combining It w/ 3D Models In Power BI” →

Checking out the Window Clause in Azure SQL and SQL Server 2022

Posted on by Annie D

Partitioning is nice in SQL, but how about using the WINDOW clause to make it more efficient? Patrick looks at how to use this function with Azure SQL and SQL Server 2022!

SELECT – WINDOW – (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— <a href="https://guyinacube.com" Continue reading “Checking out the Window Clause in Azure SQL and SQL Server 2022” →

Connecting The Military Community w/ Data Jobs | Innovations In Power BI & Power Platform Summit

Posted on by Annie D

Session 2: Connecting The Military Community w/ Data Jobs

When is it?
February 21st – 2pm Los Angeles (PST), 5pm New York (EST), 10pm London (GMT)
February 22nd – 9am Sydney (AEDT), 11am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Chris Aragao, Certified Power BI Data Analyst Associate

During This Free Event, You Will:

• Connect to various data sources, including APIs, and retrieve, transform, and manipulate data in a variety of ways using M code
• Discover specific cleaning and modeling techniques to ensure data accuracy and reliability
• Continue reading “Connecting The Military Community w/ Data Jobs | Innovations In Power BI & Power Platform Summit” →