Power BI color based on value is like giving your data a makeover to make it easier to understand. Imagine you have a bunch of numbers representing sales for different products. You can tell Power BI to change the color of those numbers depending on how high or low they are compared to a certain … read more…
As we know, the Power Apps Date picker does not have a time picker control [like Hour/Minute/Seconds] by default. If Power Apps could provide developers with this feature, it would be extremely helpful. As this PowerApps time picker feature is not available in Power Apps Date picker, we can use a Dropdown control to select … read more…
Let’s say you need to add a new column to a large Power BI table depending on certain criteria. In this case, the conditional column option in Power BI is really helpful as it significantly simplifies the work. In this Power BI tutorial, I will explain how to add Conditional column in Power BI and … read more…
Power BI Date Hierarchy organizes dates into different levels of granularity, such as year, quarter, month, and day. In this tutorial, we will learn how to create date hierarchy in Power BI and how to work with Power BI add week to date hierarchy. Also, we will cover the topics below: Power BI Date Hierarchy … read more…
In SharePoint, you might want to display a page, file, or folder in a web part; the SharePoint Page Viewer web part is the best option for this. The page viewer web part is only available on a Classic SharePoint site. However, the Modern SharePoint site does not support it. If you want to display … read more…
In this Power BI Tutorial, we will learn about the Power BI Group By function and Power BI Count Group By. Also, we will cover the topics below: Power BI Group By function Power BI GROUP BY is a function used in the query editor or in DAX (Data Analysis Expressions) to combine data based … read more…
One of my clients provided a requirement to create a pagination in the Power Apps application. Additionally, they want to use the Gallery control and a Dropdown control to make pagination more attractive and responsive. This Power Apps article explains how to create pagination in PowerApps, pagination in PowerApps gallery, and pagination in Power Apps … read more…
Recently, I was creating an Asp.Net web application for a SharePoint POC where we wanted to display SharePoint list data using CSOM (Client side object model using C#.Net), but I got an error as: Could not load file or assembly ‘Microsoft.AI.Web’ or one of its dependencies. The system cannot find the file specified. Description: An … read more…
One of my clients provided a requirement to display a SharePoint document/file in the Power Apps application. Additionally, they want to use the Search Bar, Open File, Zoom In, and Zoom Out functions of PDFs [much way your Windows, Mac OS, and Android devices’ local PDF reader software does]. To achieve this, Power Apps provides … read more…
A Power BI Date Slicer is like a magic wand for your data. It lets you easily filter and visualize your data based on dates. Think of it as a virtual tool that helps you slice and dice your data by time periods such as days, weeks, months, or even years. In this tutorial, we … read more…
I recently received a task in which I needed to remove the first and last characters from a string and all spaces from the string in Power Apps. Fortunately, Microsoft Power Apps provides Trim and TrimEnds Functions to achieve this. In this Power Apps tutorial, I will explore all the information about the Power Apps … read more…
When working in Power BI, you might encounter a situation where your data has merged columns, such as having too much information in one column, like “PowerBIDesktop.“ In that case, you can use Power BI’s Split Column option to divide that column into multiple columns, like “Power BI Desktop.“ In this tutorial, we will learn … read more…
Recently, I got an opportunity to work with the Now, Today, IsToday, and UTCNow functions to get the current date and time, current date without time, date format, etc. In this Power Apps tutorial, I will explore all about PowerApps now() format, PowerApps now() timezone, Power Apps today format, Power Apps today date without time, … read more…
One common task in data analysis is working with dates. Power BI Power Query provides functions for working with dates, including getting the current date and other date-related functions. In the tutorial, I will discuss Power Query Today Date in Power BI and Power Query Today Minus 7 days. Also, we will cover the topics … read more…