21
157 780

How to Design Power BI Report Professionally

17:33

How to Connect to Oracle Database via Power BI - Issues Fixed

8:04

How to Use MEASURE FILTERS in Power BI

11:53

How to Make Dynamic Custom Arrows in Power BI

10:53

How to Create Dynamic Top N in Power BI Slicer

13:47

12 Most Used DAX Functions in Power BI

29:13

Select Multiple Measures in Power BI Slicer

In this Video, we are going to see how to select multiple measures from a slicer and have the chart show those measures. It is especially useful when you want to see different calculations selectively in your visuals.
Different Measures Based on Slicer Selection:
czcams.com/video/tljRYGz15PA/video.htmlsi=np-r7Ay4qYKbzkgN
BI Land: czcams.com/users/BILand
Watch this to learn 12 most used DAX functions in Power BI:
czcams.com/video/d-zPxpkgISc/video.html
Subscribe to My Channel:
www.youtube.com/@BILand/videos?sub_confirmation=1

zhlédnutí: 572

Video

How to Design Power BI Report Professionally

17:33

How to Design Power BI Report Professionally

zhlédnutí 460Před 6 měsíci

Report design is extremely important in the professional world. Even if your report does a great job with numbers and calculations, if it does not look great and pro, most likely no one is going to use it. Don’t waste any time and apply these steps to make your Power BI report stand out. BI Land: czcams.com/users/BILand How to Create a Home Page in Power BI czcams.com/video/-9TbvHkn5HA/video.ht...

How to Connect to Oracle Database via Power BI - Issues Fixed

8:04

How to Connect to Oracle Database via Power BI - Issues Fixed

zhlédnutí 5KPřed 7 měsíci

In this video, I will show how to connect to an oracle database, load data into Power BI and solve the most recurrent issues. BI Land: czcams.com/users/BILand Watch this to learn 12 most used DAX functions in Power BI: czcams.com/video/d-zPxpkgISc/video.html

11:53

How to Use MEASURE FILTERS in Power BI

zhlédnutí 9KPřed 10 měsíci

In this video, we are going to learn how to apply a measure filter in Power BI. In many cases, you will need to use a measure to filter your visuals. Let’s learn this with two examples. We will see the potential dangers of measure filters as well. 0:00 Introduction 01:29 Apply a measure as filter - example 1: measure filter on slicer for date range. 07:19 Apply a measure as filter - example 2: ...

How to Make Dynamic Custom Arrows in Power BI

10:53

How to Make Dynamic Custom Arrows in Power BI

zhlédnutí 4,7KPřed 11 měsíci

In this video, we are going to make customs arrows to be able to visualize the KPIs much better. We will use DAX measure and conditional formatting. Creating arrows or the icons using measure will provide you much more possibilities in presenting your indicators to top management. BI Land: czcams.com/users/BILand Compare Two Time Periods or Dates Dynamically: (HIGHLY RECOMMENDED) czcams.com/vid...

How to Create Dynamic Top N in Power BI Slicer

13:47

How to Create Dynamic Top N in Power BI Slicer

zhlédnutí 4,5KPřed 11 měsíci

In this video, we are going to make a measure that works dynamically according to the selection of the top in the slicer. It will also respect all other filters if selected. Moreover, you will learn the difference between ALL and ALLSELECTED in DAX BI Land: czcams.com/users/BILand Watch this to learn 12 most used DAX functions in Power BI: czcams.com/video/d-zPxpkgISc/video.html Watch this to l...

29:13

12 Most Used DAX Functions in Power BI

zhlédnutí 3,3KPřed rokem

In this video we are going to learn 12 most used DAX functions in Power BI. This is part of the “absolutely essentials” for Power BI. We will use each function with practical and real-world business examples. 0:00 Introduction 00:22 SUM Function in Power BI 02:07 COUNT Function in Power BI 04:02 CALCULATE, FILTER and BLANK DAX Functions 07:22 MAX and MIN in Power BI 09:05 IF and HASONEFILTER Fu...

11:04

How to Lookup in Power BI - Advanced

zhlédnutí 1,2KPřed rokem

In this video, we are going to see how to look up a value between two values in another table with no unique keys between the two tables. You will surely encounter this need in your business as a data analyst.This video provides practical example to comprehend the subject fully. It will also help you understand building filter table inside a variable in Power BI and SSAS. BI Land: czcams.com/us...

11:36

How to Create a Home Page in Power BI

zhlédnutí 10KPřed rokem

In this video, we are going to see how to create a home page in Power BI for easier navigation through other pages. Home page is also useful to apply main filters before entering the reports pages. Additionally, we can host important information concerning the whole report in the Home Page. This video provides practical tips that are very useful for building reports in real business world. 0:00...

How to Show Several Months Based on Single Slicer Selection

19:41

How to Show Several Months Based on Single Slicer Selection

zhlédnutí 1,4KPřed rokem

If you need to select single month but show several previous months, or from the beginning of the year in your charts, watch this video. We often face this kind of requirements in real BI projects. This video will help you boost your DAX. In this video, we will see the following DAX functions: DATESINPERIOD REMOVEFILTERS KEEPFILTERS Master Calendar in Power BI and SSAS: czcams.com/video/Oq5WOmo...

How to Show Power BI Report on the Last Available Date by Default

12:26

How to Show Power BI Report on the Last Available Date by Default

zhlédnutí 7KPřed 2 lety

Imagine you have published a report to power BI services, and then you have scheduled the dataset to be refreshed. How can you make your report to be filtered always on the last available date after a refresh.? It means that you want your report to show always according to the last date available in your data. In this video, we are going to see how to make this possible. Enjoy it! 0:00 Introduc...

How to Use Variables in Power BI - Replace EARLIER

17:05

How to Use Variables in Power BI - Replace EARLIER

zhlédnutí 1,5KPřed 2 lety

In this video, we are going to use variables to replace EARLIER Dax function with 4 practical examples. This video will help you to understand how variables really work in power BI and SSAS Enjoy it! 0:00 Introduction 0:44 Example 1: Prior highest record 7:39 Example 2: Ranking 10:39 Example 3: Percent of total 13:25 Example 4: Next study date 16:35 Conclusion Watch this to learn EARLIER thorou...

27:05

The Most Complex DAX Function Made Easy

zhlédnutí 3,4KPřed 2 lety

In this video, we are going to deep dive into understanding EARLIER Dax function with 4 practical examples. It is true that Variables now can replace EARLIER function. Yet understanding EARLIER will help deepen your DAX knowledge tremendously. Enjoy the video! 0:00 Introduction 1:10 Example 1: Prior Highest Record 10:45 Example 2: Ranking 16:45 Example 3: Percent of Total 21:05 Example 2: Next ...

Dynamic Segmentation & Clustering in Power BI - Boost Your DAX

14:54

Dynamic Segmentation & Clustering in Power BI - Boost Your DAX

zhlédnutí 8KPřed 2 lety

In this video, we learn how to make dynamic segmentation. It is a very useful method to cluster the fields based on measures. The DAX used for this subject is somehow advanced, yet it is explained thoroughly. Enjoy the video!

How to Make Dynamic Axis Using DAX in Power BI

25:35

How to Make Dynamic Axis Using DAX in Power BI

zhlédnutí 4,2KPřed 2 lety

In this video, we are going to explore making dynamic axes using DAX measures. This method will allow you to manage complex as well as easy cases. We will use UNION, SELECTEDCOLUMNS, DISTINCT, SWITCH, SELECTEDVALUE, PREVIOUSQUARTER, PREVIOUSYEAR and some other DAX functions. 0:00 Introduction 3:38 Combine different columns into one in power BI 10:05 Measure for dynamic axis 16:06 Percentage cha...