Fernan
Fernan
  • Видео 429
  • Просмотров 4 958 820
FIX CIRCULAR DEPENDENCY ERROR / 2 Common Scenarios and how to fix them / Beginners Guide to Power BI
In this video were going to look at the circular dependency error that you get when using DAX calculations. We're going to look at the two most common scenarios and how to deal with them.
🕓 TIMESTAMPS
0:00 - Intro
01:32 - Model preview
03:25 - Error caused by a column
09:33 - Error caused by a table
-
📣 Get Demo Files HERE
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/...
Просмотров: 673

Видео

EXTRACT DATA from PDF files into POWER BI or EXCEL using POWER QUERY // Beginners Guide to Power BI
Просмотров 83414 часов назад
In this video were going to look at how you can extract table data from PDFS into Excel or Power BI. We're also going to look at how you can combine multiple PDF files the easy way. 🕓 TIMESTAMPS 0:00 - Intro 00:45 - Getting data from PDF 03:42 - Combining from multiple PDFs 08:15 - Getting invoice dates - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COUR...
How to HIGHLIGHT and FILTER MISMATCHES in your Power BI Reports // Beginners Guide to Power BI
Просмотров 1,8 тыс.День назад
In this video were going to look at how you can distinguish mismatches between two sets of data, while also using a measure to provide a filter to choose what to show in your tables. 🕓 TIMESTAMPS 0:00 - Intro 02:50 - Finding Mismatches 04:36 - Adding Colours 08:57 - Adding Slicers - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COURSE to get the essential...
JUNE 2024 POWER BI UPDATE // PBIR format, Visual Calculations, Show Visuals as Tables AND MORE
Просмотров 2 тыс.День назад
In this video were going to look at some of the new updates from the June 2024 Feature Summary. powerbi.microsoft.com/en-us/blog/power-bi-june-2024-feature-summary/#:~:text=Welcome to the June 2024,in Power BI Report Builder. 🕓 TIMESTAMPS 0:00 - Intro 00:42 - Visual calculations 01:29 - PBI Home 01:58 - Large semantic models 02:43 - INFO functions 03:25 - Mobile view 03:59 - PBIR 05:00 - Publis...
GET ORGANISED using FOLDERS in POWER BI // How to use and limitations // Beginners Guide to Power BI
Просмотров 2,1 тыс.14 дней назад
LINK: blog.fabric.microsoft.com/en-us/blog/announcing-folder-in-workspace-in-public-preview In this video were going to look at folders and how you can use them to get organised with your Power BI items in the Power BI Service 🕓 TIMESTAMPS 0:00 - Intro 01:15 - Creating folders 03:02 - Publishing into folders 04:48 - Permissions 05:28 - Subfolders 07:04 - Unique report names in workspaces - 📣 Ge...
QUICK LOOK AT NEW LAYOUTS for MATRIX VISUALS in Power BI // Beginners Guide to Power BI
Просмотров 2,6 тыс.14 дней назад
In this video were going to look at the new layout options available for the matrix visuals in Power BI Reports. 🕓 TIMESTAMPS 0:00 - Intro 03:22 - Compact 04:59 - Outline 06:48 - Tabular 08:35 - Simple Cashflow - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required. solutionsabroad.thinkific.com...
RECOMMENDED SETTINGS for POWER BI DESKTOP // A Quickstart Guide for First Timers in Power BI
Просмотров 1,1 тыс.21 день назад
In this video were going to look at some of my recommended settings to bear in mind when installing and configuring Power BI Desktop for the first time. 🕓 TIMESTAMPS 0:00 - Intro 00:43 - Downloading the correct way 02:21 - Sign in to Power BI Account 03:36 - Settings to toggle 07:36 - Preview features 08:41 - External tools - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data...
ADD BELL ICON to your Power BI Reports THE EASY WAY // Beginners Guide to Power BI
Просмотров 2,4 тыс.21 день назад
In this video were going to look at how to create a notification bell icon for your Power BI Reports LINK to Jasons Solution to Clear Notification - ruclips.net/video/c3kWGLYMHsc/видео.htmlsi=NVftth94WxmAjruH 🕓 TIMESTAMPS 0:00 - Intro 01:15 - Preview 02:30 - Data 02:56 - Setting Up Visuals 11:22 - Setting up Bookmarks - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Chec...
FIRST LOOK at TASK FLOWS for FABRIC and how to use them in POWER BI // Beginners Guide to Power BI
Просмотров 2,1 тыс.28 дней назад
LINK: learn.microsoft.com/en-us/fabric/get-started/task-flow-overview In this video were going to look at this new task flow feature in the Power BI Service and how you can utilise them to design your data architectures in Fabric. 🕓 TIMESTAMPS 0:00 - Intro 02:03 - Creating from Scratch 06:58 - Pre-created Task Flows 08:40 - My recommendations - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to ...
Preview PBIX Files in SharePoint and OneDrive for Business // Basic Usage and Limitations
Просмотров 808Месяц назад
LINK: learn.microsoft.com/en-us/power-bi/collaborate-share/service-sharepoint-viewer In this video were going to look at this new feature that lets you preview PBIX files directly in SharePoint and OneDrive for Business. 🕓 TIMESTAMPS 0:00 - Intro 01:32 - Preview 01:55 - Enabling Feature 02:19 - Feature rundown 05:56 - PBIX only 06:22 - 1GB file preview limit 06:54 - File access 07:04 - Power BI...
MAY 2024 POWER BI UPDATE // Preview PBI files in SharePoint, Copilot Updates AND MORE
Просмотров 3,9 тыс.Месяц назад
LINK: powerbi.microsoft.com/en-us/blog/power-bi-may-2024-feature-summary/#post-27048-_Toc167109006 In this video were going to look at some of the new features from the May 2024 update. 🕓 TIMESTAMPS 0:00 - Intro 00:41 - Modern Tooltips 01:24 - New Matrix Layout 02:07 - On object interaction updates 02:35 - Pane manager 02:55 - Publish to folders 03:38 - Ask questions to Copilot 04:12 - DAX Quer...
HOW TO JOIN DATA // How to use SEMI JOINS // Beginners Guide to using MERGE and RELATIONSHIPS
Просмотров 1,3 тыс.Месяц назад
In this video were going to look at how to join your data in Power BI. 🕓 TIMESTAMPS 0:00 - Intro 03:38 - Merge Queries 08:59 - Semi Joins 11:34 - Fuzzy Joins 14:18 - Relationships 16:17 - Multiple relationships - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required. solutionsabroad.thinkific.com...
How to use URLs and HYPERLINKS in Power BI // Dynamic URLs, Mailto AND MORE
Просмотров 1,8 тыс.Месяц назад
In this video were going to look the different visuals you can add hyperlinks to, and the different ways you can utilise them. 🕓 TIMESTAMPS 0:00 - Intro 01:44 - Basic Setup 05:02 - Dynamic URLs 06:51 - Buttons 09:06 - Shapes & Images 09:39 - Textbox 10:51 - Mailto - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need....
IMPORT IMAGES into POWER BI // DIFFERENT WAYS to Import and Use Images in Power BI Reports
Просмотров 3,2 тыс.Месяц назад
In this video were going to look at a couple different ways you can import and use images into your Power BI Reports. 🕓 TIMESTAMPS 0:00 - Intro 01:08 - Basic Import 02:25 - Using Web Images 05:50 - Using Binary Images 12:45 - SVG Images - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required. sol...
AUTO REFRESH POWER BI VISUALS FOR BIG SCREENS! A Step by Step Guide + Limitations and Considerations
Просмотров 1,6 тыс.Месяц назад
In this video were going to look at how to set up the auto visual refresh feature in storytelling for PowerPoint add in. We'll look at how it works and some of its limitations to bear in mind. 🕓 TIMESTAMPS 0:00 - Intro 03:08 - Setting up report 05:34 - Setting up Power Point 09:02 - Re-embed required 10:55 - Auto refresh on slideshow mode only 11:52 - Limit up to 15 seconds - 📣 Get Demo Files H...
POWER QUERY GET DATA IN REPORT BUILDER! Paginated Reports Experience, Limitations and Considerations
Просмотров 1,7 тыс.Месяц назад
POWER QUERY GET DATA IN REPORT BUILDER! Paginated Reports Experience, Limitations and Considerations
ENHANCED RLS EDITOR // Basic Setup, Dynamic RLS AND MORE // Beginners Guide to Power BI
Просмотров 2,5 тыс.2 месяца назад
ENHANCED RLS EDITOR // Basic Setup, Dynamic RLS AND MORE // Beginners Guide to Power BI
NEW LINE ENHANCEMENTS & 100% STACKED AREA CHART In Power BI Desktop // What's New?
Просмотров 1,2 тыс.2 месяца назад
NEW LINE ENHANCEMENTS & 100% STACKED AREA CHART In Power BI Desktop // What's New?
SCAN BARCODES to FILTER POWER BI REPORTS? A Step by Step Guide from Scratch
Просмотров 1,5 тыс.2 месяца назад
SCAN BARCODES to FILTER POWER BI REPORTS? A Step by Step Guide from Scratch
APRIL 2024 POWER BI UPDATE // 100% Stacked Area Chart, Auto Refreshing PowerPoint AND MORE
Просмотров 3 тыс.2 месяца назад
APRIL 2024 POWER BI UPDATE // 100% Stacked Area Chart, Auto Refreshing PowerPoint AND MORE
QUICK INTRO to M QUERY in POWER BI and EXCEL // Beginners Guide to Power BI in 2024
Просмотров 1,4 тыс.2 месяца назад
QUICK INTRO to M QUERY in POWER BI and EXCEL // Beginners Guide to Power BI in 2024
PERFECTLY ALIGNED VISUALS in Power BI // Different Ways to Align // Beginners Guide to Power BI
Просмотров 2,1 тыс.2 месяца назад
PERFECTLY ALIGNED VISUALS in Power BI // Different Ways to Align // Beginners Guide to Power BI
REST APIs with PAGINATION OR TOKENS with POWER BI Reports // Beginners Guide to Power BI in 2024
Просмотров 4 тыс.2 месяца назад
REST APIs with PAGINATION OR TOKENS with POWER BI Reports // Beginners Guide to Power BI in 2024
MOBILE LAYOUT VIEW for MOBILE OPTIMIZED EXPERIENCE // Beginners Guide to Power BI in 2024
Просмотров 1,6 тыс.2 месяца назад
MOBILE LAYOUT VIEW for MOBILE OPTIMIZED EXPERIENCE // Beginners Guide to Power BI in 2024
QUICK GUIDE TO POWER BI FILE FORMATS // PBIX, PBIT, PBIDS, PBIP, PBIR, PBIDS, TMSL, TMDL
Просмотров 2,5 тыс.3 месяца назад
QUICK GUIDE TO POWER BI FILE FORMATS // PBIX, PBIT, PBIDS, PBIP, PBIR, PBIDS, TMSL, TMDL
MARCH 2024 POWER BI UPDATE // Mobile Auto Create, DAX Query View with Copilot AND MORE
Просмотров 3 тыс.3 месяца назад
MARCH 2024 POWER BI UPDATE // Mobile Auto Create, DAX Query View with Copilot AND MORE
Introduction to TMDL (Tabular Model Definition Language) // What is it? TMSL vs TMDL // Quick Guide
Просмотров 2,2 тыс.3 месяца назад
Introduction to TMDL (Tabular Model Definition Language) // What is it? TMSL vs TMDL // Quick Guide
VISUAL CALCULATION TEMPLATE FUNCTIONS // How to use these built-in templates in Power BI
Просмотров 1,2 тыс.3 месяца назад
VISUAL CALCULATION TEMPLATE FUNCTIONS // How to use these built-in templates in Power BI
QUICKLY EXPLORE your SEMANTIC MODELS in Power BI Service using the EXPLORE Feature
Просмотров 2,8 тыс.3 месяца назад
QUICKLY EXPLORE your SEMANTIC MODELS in Power BI Service using the EXPLORE Feature
NATIVE OVERLAPPING BARS in POWER BI // IBCS Style Variance Bar Chart Step by Step Guide
Просмотров 4,1 тыс.3 месяца назад
NATIVE OVERLAPPING BARS in POWER BI // IBCS Style Variance Bar Chart Step by Step Guide

Комментарии

  • @adiprabowo-wo4rc
    @adiprabowo-wo4rc 11 часов назад

    Hi Fernan, it's interesting feature, thank you for sharing Is it applicable to QR code ?

  • @mayramedina2779
    @mayramedina2779 17 часов назад

    Huge help my friend!!! Thank you very much!

  • @kel78v2
    @kel78v2 19 часов назад

    Can i just ask whether it’s really an issue if one can’t create dax columns but it still allows you to add custom columns directly to the tables?

  • @jatinbali3307
    @jatinbali3307 22 часа назад

    Having some issues the middle part where amount any quantity display but in my case product is showing in multiple pages. can anyone guide on this please

  • @JohnSullivan1
    @JohnSullivan1 23 часа назад

    This was very helpful. Thank you for all of your videos.

  • @ElectronicBarta
    @ElectronicBarta День назад

    really great. you save my time. thanks for sharing.

  • @user-ks6pi1ms6w
    @user-ks6pi1ms6w День назад

    thank you bro it helped me alot

  • @shanabenjamin8945
    @shanabenjamin8945 День назад

    Nyce!

  • @jozsefkotai8203
    @jozsefkotai8203 2 дня назад

    The best opportunity for TOPN calculation, Thanks !

  • @amyperalt
    @amyperalt 2 дня назад

    I have followed all the steps but when I check the next day it didn't refresh. and when we give incremental refresh to desktop will it not allow to refresh in services?

  • @erinfield1943
    @erinfield1943 2 дня назад

    4:47- calendar table 5:14- total sales measure 6:30- total sales previous year measure 9:21- measure for conditionally formatting the colours

  • @rishimukherjee5116
    @rishimukherjee5116 2 дня назад

    Can you share the calendar table in description box?

  • @adahir12
    @adahir12 2 дня назад

    Thank you, this video was very informative. I was trying to cluster my data, but option that you selected "Automatic data clustering " not available in my Power BI desktop. Can you help me with that?

  • @danielrasc7050
    @danielrasc7050 2 дня назад

    Is tehere a way to select the lenguage in the Power Bi report?

  • @SKCourier
    @SKCourier 3 дня назад

    I have pdf but sometimes it has 4 columns and sometimes 5 times hence it is not importing properly. I have to manually adjust column. I have around 1000 pdfs

    • @hasnahameed
      @hasnahameed 2 дня назад

      Same question Not always in same rows Row headers and Column Header are not always at the same place 😢

  • @ChanakyaPola
    @ChanakyaPola 3 дня назад

    Is there a way we could default the axes to months instead of days?

  • @boycool123456789
    @boycool123456789 3 дня назад

    I am trying to search Azure Active directory in marketplace, but I am not able to find it, can you please help me?

  • @RenitaDsilva-b9e
    @RenitaDsilva-b9e 3 дня назад

    I want to be able to export data from my PowerBi to Google sheets directly without having to save in excel and then paste in Google sheets. Can you share a process that would help in automating this and if you could share it on your channel it would be helpful.

  • @garudabowo
    @garudabowo 3 дня назад

    what if you already break the links, can you still fix it manually in order to make it link again for future purpose?

  • @garudabowo
    @garudabowo 3 дня назад

    Surprisingly good. I use power BI and learn more from here in an instant tube. Good job man

  • @tbot5709
    @tbot5709 3 дня назад

    Disappointing, learn nothing...expecting something like power automate taking PBI data into excel at certain interval...

  • @victorlfc
    @victorlfc 4 дня назад

    Really insightful. At first I thought creating calculated column with the corresponding values for greater, less or equal. But this solution is much better for memory and speed. Thanks!

  • @mart1484
    @mart1484 4 дня назад

    7:50 ALL SELECTED

  • @utkarshrajput5871
    @utkarshrajput5871 6 дней назад

    But this does not work in power bi online version

  • @nonoobott8602
    @nonoobott8602 6 дней назад

    This is so brilliant. I've learned so much watching your videos. Thanks for sharing

  • @user-hy5qu1en8p
    @user-hy5qu1en8p 7 дней назад

    Thanks farnan

  • @simaomuhongo_mostech361
    @simaomuhongo_mostech361 7 дней назад

    Thanks , very clearly and insightful. Keep going on this

  • @jeremrndn
    @jeremrndn 7 дней назад

    Thanks a lot for this video! Now, what if you want to dynamically create this TOP N, but adding a condition "Total Orders > 100" for example? On my side, using the Visual level filter does not work, the TOP N is not dynamic, ending with 3 products instead of TOP5.

  • @widodomurnoto5440
    @widodomurnoto5440 7 дней назад

    Thank you Fernan, you solved my problem

  • @TheJaebeomPark
    @TheJaebeomPark 7 дней назад

    you are so good!

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

    Hi Fernan, You explained everything but it would be better if you would have added detailed difference between all ?

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

    Hi Fernan, I wish you have told more about github (Forkes & Branches )

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

    How do we "unbold" the row headers in a tabular view? I've been trying to figure out where to change this in the settings but I can't find where. 😢

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

    I think you should have put this video somewhere in the beginning . It would have been easier to pay attention on what you are doing in the rest of the videos.

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

    Hi. Great content! A question: how to connect to a folder instead in OneDriver personal? Like for list the existing files and choose which one to use?

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

    I m using spark line in Matrix visual. Showing sales for last 10 months. The trend line is not showing the correct months in order. How can we sort the month in spark lines. Appreciate your response.

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

    Thank for sharing 😊

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

    Excellent 🎉..thanks for sharing...

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

    Hi Fernan I have this measure that returns text such as 50/12% BAC+ = IF([# BAC+]>0, FORMAT([# BAC+],"0") & "/" & FORMAT([% BAC+],"0%"),"") I want to conditionally format this measure using the following measure Met Bac+ target = IF( [bac+ target]<1, "", IF( [% BAC+] < [bac+ target] * [lower bound], "#FF4136", -- Target Not Met IF( [% BAC+] < [bac+ target]*[middle bound], "#FF8F00", -- Close to Target "#2E7D32" -- Target Met ) ) ) however, Power BI does format the text values, what am I doing wrong in this case? Thank you for all your education

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

    6:04- OMG this has happened to me!

  • @syedghousebasha5402
    @syedghousebasha5402 9 дней назад

    Hi, Embed option not available in my onedrive file.. Can u help

  • @kel78v2
    @kel78v2 9 дней назад

    Backward comparison with SAMEPERIODLASTYEAR works just fine. What I've noticed is when you're looking at YTD vs last year. For example 2024 YTD would show you the totals up to June 2024 BUT SAMEPERIODLASTYEAR will show the 12 months total for 2023 instead of Jan to June 2023?

  • @sergeypautov8086
    @sergeypautov8086 9 дней назад

    Феноменально! You are great brainMAN!

  • @matusjakubcin2765
    @matusjakubcin2765 9 дней назад

    Hello , thanks for video :) Could i ask you which version of Power BI you are using ? i mean in Data labels part you have extra options like : Title , Detail , Layout , which is later used. I have version October 2023 but do not have such option. Or is there any way , how can i change difference shown in percentage , only with options i have ( options , values , background ) . Thanks

  • @mneama4383
    @mneama4383 10 дней назад

    Bravooo bro , may i have your email , i have couple of questions if u can help me with

  • @enocharthur4322
    @enocharthur4322 10 дней назад

    I'm here first🎉🎉🎉🎉

  • @PGJAS
    @PGJAS 11 дней назад

    Hi, sync slicer option and copy, paste and sync both will have same functionality and it is just different ways for synchronizing right? Or is there any advantage of using 'copy, paste and sync' over sync slicer?

  • @JubranZakri
    @JubranZakri 11 дней назад

    Cant thank you enough

  • @lalitsoni3596
    @lalitsoni3596 12 дней назад

    sir will share to ppt also show web visual? i have dashboards with Map visuals when i embedded them into web it does not show visuals to users , is there any other way to show full dashboard with maps and all to users outside the organization ?

  • @sugiplanner
    @sugiplanner 13 дней назад

    Why my workplace doesn't enable menu for schedule refresh?