Data Visualization - PSYCHOLOGICAL STATISTICS

Learning Power BI: How to Use Conditional Formatting in Bar Charts

The Importance of Conditional Formatting in Data Visualization In modern data visualization, merely displaying data is often insufficient for driving business decisions. Effective reporting requires techniques that highlight critical insights immediately, guiding the user’s attention to areas that require action or closer scrutiny. This is where conditional formatting becomes an indispensable tool within reporting platforms […]

Learning Power BI: How to Use Conditional Formatting in Bar Charts Read More »

Learning to Use Conditional Formatting on Power BI Cards

Harnessing Conditional Formatting for Dynamic Power BI Cards In the realm of data visualization, quick insight delivery is paramount. One of the most common requirements when designing interactive dashboards in Power BI is the ability to draw immediate attention to key performance indicators (KPIs) based on their underlying values. While many visuals, such as tables

Learning to Use Conditional Formatting on Power BI Cards Read More »

Learning Z-Score Calculation with Power BI: A Step-by-Step Guide

In the realm of statistics and data analysis, the Z-score is a fundamental metric used to quantify the distance of a data point from the mean of a dataset. Specifically, a z-score tells us exactly how many standard deviations a particular value lies away from the population mean. This standardization process, often referred to as

Learning Z-Score Calculation with Power BI: A Step-by-Step Guide Read More »

Learning to Count Distinct Values in Power BI Using DAX

Understanding the Need for Distinct Counting in Data Analysis In modern data analytics, particularly when working within robust platforms like Power BI (Business Intelligence), accurately assessing data cardinality is fundamental. Data analysts frequently need to determine how many unique items exist within a dataset rather than simply counting the total number of records. This concept,

Learning to Count Distinct Values in Power BI Using DAX Read More »

Learning Guide: Understanding and Calculating Correlation Coefficients in Power BI

A correlation coefficient is a measure of the linear association between two variables. It can take on a value between -1 and 1 where: -1 indicates a perfectly negative linear correlation between two variables 0 indicates no linear correlation between two variables 1 indicates a perfectly positive linear correlation between two variables The easiest way to

Learning Guide: Understanding and Calculating Correlation Coefficients in Power BI Read More »

Learning Power BI: How to Remove the Total Row from Tables

Often you may want to remove the “Total” row from a table in Power BI. Fortunately this is easy to do and the following example shows how to do so in practice. Example: How to Remove “Total” Row in Power BI Suppose we have the following table in Power BI named my_data that contains information

Learning Power BI: How to Remove the Total Row from Tables Read More »

Learning Power BI: Filtering Slicers to Remove Blank Options

If you have a table with blank values in Power BI and you create a slicer in a report, then a (Blank) option will appear in the slicer, such as the following slicer: Often you may want to remove this option from the slicer since it usually doesn’t make since to slice data based on

Learning Power BI: Filtering Slicers to Remove Blank Options Read More »

Learning to Hide (Blank) Values in Power BI Card Visualizations

If you have a table with blank values in Power BI and you add a card visualization to a report, it’s possible that a (Blank) value will appear in the card, such as the following card: The easiest way to hide this (Blank) value is to use the Conditional formatting feature within the Visualizations tab

Learning to Hide (Blank) Values in Power BI Card Visualizations Read More »

Learning to Calculate Standard Deviation in Power BI with DAX: A Step-by-Step Guide

You can use the following syntax in DAX to calculate the standard deviation of values in a column: Std Dev of Points = STDEV.P(‘my_data'[Points]) This particular example creates a new measure named Std Dev of Points that calculates the standard deviation of values in the Points column of the table named my_data. Note that there

Learning to Calculate Standard Deviation in Power BI with DAX: A Step-by-Step Guide Read More »

Learning to Calculate the Median in Power BI with DAX: A Step-by-Step Guide

Understanding the Median and Its Importance in Data Analysis The median is a fundamental concept in statistics, representing the middle value of a dataset when that data is sorted in order of magnitude. Unlike the average (mean), the median is highly resistant to skewness caused by outliers, making it a critical metric for understanding the

Learning to Calculate the Median in Power BI with DAX: A Step-by-Step Guide Read More »