Articles about power bi

Can't See Create Folder Option in Power BI Workspaces: A Guide for Admins

If you're an admin trying to create subfolders within a Power BI workspace and can't see the option, this article provides a solution. Learn how to enable the feature for your tenant, even if it hasn't been released yet.

Formatting Matrix Data in Power BI: A Tech Support Guide

Learn how to format a matrix visual in Power BI to highlight the first and last 12 months of data with a certain color, leaving the middle 12 months in the default color. This tech support guide will help you make the most of your data in Power BI.

Troubleshooting Match Index Breaks with Slicer in Lookup Array

In this tech support article, we'll discuss a common issue encountered when using the Slicer feature in Power BI with Lookup Arrays, where the Match Index breaks, affecting the way values are displayed. We'll provide some suggestions to help you troubleshoot and resolve this issue.

Workaround: Choosing Visuals Affects Drill-through in Power BI

Learn how the choice of visuals can impact drill-through functionality in Power BI and discover a workaround to optimize your reporting. Keywords: Power BI, visuals, drill-through, report, workaround.

Creating Custom Regions Map in Power BI: A Comprehensive Guide

In this article, we will explore how to create a custom regions map in Power BI using a sample dataset containing regions such as Southwest, Northeast, Pacific Northwest, Canada, and Quebec. This guide will provide step-by-step instructions on how to create, customize, and publish your map, helping you to effectively visualize your geographic data.

Effortlessly Rename Multiple Visuals or Pages in Power BI

Automating the process of renaming multiple visuals or pages in Power BI can save you time and increase efficiency. Learn how to utilize the power of 'CityAddress', 'Values', and 'Dollars' fields in tables for a seamless experience in Power BI report creation.

Power BI: Working with Multiple Slicers and Multiple Selection Conditions

Learn how to work with multiple slicers and multiple selection conditions in Power BI to filter items based on given criteria.

Formatting Long Paragraphs in Excel for Power BI Dashboard

Learn how to format long paragraphs in Excel to prepare your data for Power BI Dashboards. This article explains how to remove spaces, tabs, and new lines using various techniques.

Power BI: Error Occurred Reading Data Provider: Remote Certificate Not Valid According to Validation Procedure - PostgreSQL

This article provides a solution to the error 'Error Occurred Reading Data Provider: Remote Certificate Not Valid According to Validation Procedure' when trying to connect to a PostgreSQL database server in Power BI.

Power BI Connection Error: SSLProvider, error: 0 on SQL Server 2016

Learn how to resolve Power BI connection issues with SQL Server 2016 when encountering the SSLProvider error (0).

Two Modules with X Axis in Power BI: Column Chart Setup

In this tech support article, we'll walk you through setting up a column chart in Power BI with two modules on the X axis. Striking two layers, the first layer will strike the dates, and the second layer will display the corresponding data.

Power BI Uses Excel File: Slim Down Table Values with Custom Columns in Power Query

Learn how to use custom columns in Power Query to optimize your Excel data for use in Power BI. This tutorial provides step-by-step instructions for adding calculations to your Excel table, making it easier to analyze and visualize your data in Power BI.

Fix Number Columns in Power BI Report Builder: Top 10 by Key_Sku

Learn how to display the top 10 columns based on a value in Power BI Report Builder. This tutorial focuses on adding a new column to get the top 10 by Key_Sku and Key_Skuqty.

Calculating Monthly Headcount with DAX: Employee ID Count

Learn how to create a DAX measure in Power BI to calculate monthly headcount based on employee ID, using HireDate, TerminationDate, and TransferDate columns.

Convert Column Datatype to Whole Number Datatype (Time) in Power BI

Learn how to convert a column datatype to whole number datatype (Time) in Power BI. This tutorial will guide you through the process of changing a table's column datatype from Time to Whole Number. Follow the steps to successfully convert your Time column to a Whole Number datatype.

Power Automate: Generate Notifications for Power BI Workspace Access Changes

Learn how to use Power Automate to generate notifications for Power BI workspace access changes, including adding or removing users and updating user roles and permissions.

Passing Excel Column Data to Power BI Desktop: A Filter Data Guide

Learn how to pass Excel column data to Power BI Desktop and use it as a filter data. This guide will walk you through the process step-by-step, helping you to make the most of your data analysis and visualization. Improve your skills in data manipulation and make your reports more interactive.

How to Create a New Column in Power BI from Values from a Second Table

Learn how to create a new column in Power BI by extracting values from a second table. This article provides step-by-step instructions and tips for efficient data analysis and visualization in Microsoft Power BI.

Articles about power bi | UserComp.com