Search

Advance Card Visualization with Conditions in Power Bi

In this, I will explain the benefits of using 'Advance Card' visualization rater than using 'Card' visualization. The main advantage in 'Advance Card' feature is we can dynamically change the font and background color of the Advance Card based on conditions.
Please do the following steps to import the Advance Card,

Connect Oracle Database with Power BI

In this tutorial, I will show you, how to connect to Oracle Database with Power BI. 

Step 1: Open Power BI and Go to the 'Get Data' option 

Step 2: Select Oracle Database

UNION ALL Operator with ORDER BY Command in MYSQL

In this tutorial, I will show you how to use ORDER BY command with UNION ALL Operator.
This is common for MYSQL and Oracle.  

Let's assume following is your table named "FILM"


Comparing Integers in Java using If Statements - Source Code

In this tutorial, I will show you how to compare integers using if statements, relational operators and equality operators.

Java Calculator Game Source Code

In this tutorial, it will show how to write Java source code for Calculator Game. This is a good Java game for educational purposes.


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') {
                count++;
            }
        }
        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.