Power BI CALCULATE function with Filtering Example

In this tutorial, I will show you how to write a Power BI measure using CALCULATE function with filtering.

Step 1: Download vehicle information sheet and load it to Power BI.

Step 2: Create the following PowerBI portal (Please follow this tutorial if you don't have an idea of creating this portal)

Show Percentage Value in Power BI Pie Chart

In this tutorial, I will show you how to add Percentage Value to the data label in Power BI Pie chart. Without the percentage value, a pie chart purpose and visualization goes down and therefore it's very important to have a percentage in the data label of Pie chart.

Step 1: Setup Power BI dashboard by downloading the Vehicle profile sample data Excel.

Step 2: Drag and drop the Pie Chart to the dashboard and setup value as follows,

How to Add a Trend Line in Power BI Chart

The trendline does not come as a default option in Power BI and in this tutorial, I will show you, how to add a trend line to Power BI chart.

Step 1: Download the Vehicle profit information Excel sheet.

Step 2: Step up it in Power BI

How to Insert Average Line in Power BI Graph

In this tutorial, I will show you how to add an Average Line in Power BI graph. 

Step 1: Insert Student Information Excel data source to Power BI dashboard. 

Step 2: Have the following graph in Power BI dashboard. If you don't know how to do this - please follow this beginner tutorial

Excel Error : Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

I encountered the above error when connecting Oracle Database in Excel. How I received the error,

Step 1: Open Excel and connect to the Oracle database as below.

Java Program to Print Vowels in a String - Source Code

In this tutorial, I will show you how to count the number of Vowels in a sentence using a Java Source code. JOptionPane used here to beautify the project, but you can get a console output as well.

Step 1: Create VowelCount.java file in Eclipse (I used Eclipse as the Java IDE but you can use this file in any other Java IDEs as well)

//copyrighted by geekdecorders.blogspot.com
import javax.swing.JOptionPane;

public class VowelCount{

    public static void main(String args[]){
        String sentence=JOptionPane.showInputDialog("Enter Sentence:");
        int count = 0;
        for (int i = 0; i < sentence.length(); i++) {
            char c = sentence.charAt(i);
            if (c=='a' || c=='e' || c=='i' || c=='o' || c=='u') {
        JOptionPane one = new JOptionPane();
        JOptionPane.showMessageDialog(one,"Vowel count is" + " " + count);

Connect Power BI with MySQL Database

In this tutorial, it elaborates, how to connect MySQL Database source with Power BI tool. As a prerequisite, you have to install MySQL and Power BI in your local machine. 

Step 1: Open Power BI goto Get Data --> More Select MySQL database

Create PDFs for each Excel Rows - Tutorial

In this tutorial, I will show you how to write a VBA code in Excel to generate multiple PDFs for each Excel rows. 

Step 1: Download Student Marks Excel sheet

Count Unique Values in Power BI using DISTINCTCOUNT

In this tutorial, I will show you the usage of COUNT and DISTINCTCOUNT functions as Power BI measure. COUNT function can be used to get the total count and DISTINCTCOUNT function can be used to get the unique count.

Step 1: Follow this tutorial and load the Excel sheet to the Power BI: Download sample Excel data file.

Step 2: Right-click on one of the field and select "New Measure"

Power BI Filters with Slicer - Example for Beginners

In this tutorial, I will demonstrate - how to use Power BI filters for better visualizing the data. 

Step 1: Follow Power BI Tutorial 1 to load the Excel data and prepare the basic Power BI dashboard.
Download sample data Excel file.

Power BI with Excel Data Sheet Example for Beginners

In this tutorial, I will walk a though, how to import an Excel file to Power BI desktop and how to do a simple analysis with Excel data through Power BI.

Step 1: Install Power BI desktop on your computer: Download

Step 2: Open the Power BI desktop and load the Excel file. Download Sample Excel file.

Play MP3 in Java - Step by Step Tutorial and Source Code

In this tutorial, I will demonstrate you how to write a Java Source code to run an mp3 file. I will use Eclipse IDE for creating this project.

Step 1: Create "PlayMp3" project in Eclipse

How to Write Java Program in Eclipse Step by Step

This is a beginner tutorial and I demonstrate, how to create a “Hello World” Java Project in Eclipse IDE. I used Eclipse IDE here because it’s a free tool we can use many Java and other programming languages-based developments including Android.

Step 1: Download the Eclipse IDE and install it.

Step 2: Create a Java Project

Select File --> New --> Java Project

SOLVED - Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX) in C#

An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in XXX.exe.

I received this exception while coding and here are the steps to correct it. This code tries to add a sheet to the Excel workbook.