Power BI Archives - Slidescope

Show Images from Image URL field in Power BI Dynamically

Here’s an example dataset with image URLs that you can use to demonstrate displaying images in Power BI: Dataset Example: Animals with Image URLs Animal Name Description Image URL Cat Domestic feline https://cdn2.thecatapi.com/images/MTY3ODIyMQ.jpg Dog Domestic canine https://images.dog.ceo/breeds/hound-afghan/n02088094_1003.jpg Elephant Large mammal https://upload.wikimedia.org/wikipedia/commons/3/37/African_Bush_Elephant.jpg Panda Giant panda bear https://upload.wikimedia.org/wikipedia/commons/0/0f/Grosser_Panda.JPG Tiger Wild feline predator https://upload.wikimedia.org/wikipedia/commons/5/56/Tiger.50.jpg Steps to Use in …

Show Images from Image URL field in Power BI Dynamically Read More »

Financial Data Analysis Calculations in Power BI

DAX, Power BI / By slidescope

To calculate the desired metrics (Revenue, Gross Profit, Gross Profit %, Net Profit, and Net Profit %) using the given columns in the financial sample Excel file, follow these steps: 1. Revenue: 2. Gross Profit: 3. Gross Profit %: 4. Net Profit: 5. Net Profit %: Example Calculations: Suppose a row has the following values: …

Financial Data Analysis Calculations in Power BI Read More »

Important Financial Functions in DAX in Power BI

Power BI / By slidescope

Important Financial Functions in DAX in Power BI DAX provides several financial functions to calculate values like interest, depreciation, or loan repayment schedules. These functions are helpful in financial modeling and analysis. Here are some important financial functions with examples using a Sample Dataset: 1. PMT() Dataset: Loan ID Loan Amount (pv) Interest Rate (%) …

Important Financial Functions in DAX in Power BI Read More »

Power bi Service vs Power bi desktop

Power BI / By slidescope

Here’s a tabular comparison of Power BI Service and Power BI Desktop to highlight their key differences: Feature/Aspect Power BI Desktop Power BI Service Purpose Data modeling, report creation, and visualization development. Online platform for sharing, collaboration, and report consumption. Deployment Installed on a local machine. Cloud-based, accessed through a web browser. Data Connection Supports …

Power bi Service vs Power bi desktop Read More »

Removal Operation in Power Query in Power BI

Power BI, Power Query Editor / By slidescope

The Removal Operation in Power Query Editor in Power BI allows you to remove unnecessary rows or columns from your dataset. This is a common data-cleaning step to eliminate irrelevant or redundant information, improving dataset quality and reducing report complexity. When to Remove Rows and Columns Remove Rows: Remove Columns: Example Table: Sales Data OrderID …

Removal Operation in Power Query in Power BI Read More »

Important Filter Functions in DAX in Power BI

DAX, Power BI / By slidescope

Important Filter Functions in DAX in Power BI Filter functions in DAX are used to perform advanced filtering and retrieve specific subsets of data for calculations or visualizations. Below are some key filter functions, explained with examples using a Sample Superstore dataset. 1. FILTER() Dataset: Order ID Sales Discount 1 100 5% 2 200 15% …

Important Filter Functions in DAX in Power BI Read More »

Important Date and Time Functions in DAX (Power BI)

DAX, Power BI / By slidescope

Important Date and Time Functions in DAX (Power BI) DAX provides a variety of date and time functions to analyze and manipulate date-related data. Below are some of the most commonly used ones, explained with examples using a Sample Superstore dataset. 1. TODAY() Dataset: Order ID Order Date 1 2024-01-01 2 2024-03-15 3 2024-07-10 DAX …

Important Date and Time Functions in DAX (Power BI) Read More »

Online Retail Dataset Dashboards for Power BI

Power BI / By slidescope

The Online Retail Dataset from the UCI Machine Learning Repository, with fields such as InvoiceNo, StockCode, Description, Quantity, InvoiceDate, UnitPrice, CustomerID, and Country, is ideal for creating dashboards focused on sales, customer behavior, and inventory analysis. Below are some dashboard ideas you can create in Power BI: 1. Sales Performance Dashboard Objective: Monitor overall sales …

Online Retail Dataset Dashboards for Power BI Read More »

TOTALYTD and DATESYTD Functions in Power BI DAX

DAX, Power BI, Uncategorized / By slidescope

In Power BI DAX, both TOTALYTD and DATESYTD functions are used for year-to-date calculations, but they serve slightly different purposes and are used in different contexts. Here’s a detailed comparison along with examples. 1. TOTALYTD The TOTALYTD function is used to calculate the year-to-date total for a given measure or expression. It simplifies the process …

TOTALYTD and DATESYTD Functions in Power BI DAX Read More »

KEEPFILTERS and REMOVEFILTERS in Power BI

DAX, Power BI / By slidescope

In Power BI DAX, both KEEPFILTERS and REMOVEFILTERS are functions used to manipulate filters within calculations. Let’s delve into each with an example: 1. KEEPFILTERS: The KEEPFILTERS function is used to preserve existing filters while applying new filters within a calculation. It ensures that only the specified filters are applied, keeping all other filters intact. …

KEEPFILTERS and REMOVEFILTERS in Power BI Read More »

Power BI

Show Images from Image URL field in Power BI Dynamically

Financial Data Analysis Calculations in Power BI

Important Financial Functions in DAX in Power BI

Power bi Service vs Power bi desktop

Removal Operation in Power Query in Power BI

Important Filter Functions in DAX in Power BI

Important Date and Time Functions in DAX (Power BI)

Online Retail Dataset Dashboards for Power BI

TOTALYTD and DATESYTD Functions in Power BI DAX

KEEPFILTERS and REMOVEFILTERS in Power BI

Do you want to learn?

We are here to help.

Course benefits

Quick Links

Resource

Contact Info