Introduction Power BI IF statement is used to check whether a condition is met, it return one value if TRUE and other value if FALSE. Syntax: Return Type is single value i.e. Scalar. Example: Suppose you have a table with column ‘PARKING_SPACE_QTY’ Suppose you want to add a new column ‘Parking’ where the value is …
What is incremental refresh? Power BI incremental refresh is a feature that allows you to refresh only a subset of your data instead of refreshing the entire dataset. This can significantly improve the performance of data refreshes, especially when dealing with large datasets. Incremental refresh is commonly used when working with data sources that contain …
Introduction What is a ribbon chart? A Ribbon Chart is a sort of stacked line graph that visualizes the ranking of objects through the years. It is an evolution of the conventional stacked area chart. The Ribbon Chart distinguishes itself by its precise method of highlighting rank changes using ribbons that glide from one time …
Introduction The ease of studying Power BI can vary depending to your past experience with data handling , familiarity with statistics, and experience with similar softwares. Generally, Power BI is designed to be user-friendly and on hand to a wide range of users, which includes the ones without huge technical or information analysis backgrounds. Here …
What is a line chart? A line chart in Power Bi is used to display data points connected by line on chart. It is used to visualize trends over time. In a line chart X-axis represents time and Y-axis represents the variable How to create line chart in Power Bi ? To create a line …
Introduction Power BI is somewhat complex tool if you are working with big data and several data streams, it is good to know what needs to be optimized in order to get optimal results. Recommendation and Tips Here are the things a beginner needs to focus on for optimizing power BI reports and dashboards Data …
Introduction Power BI tooltips are used to provide extra information when the user hovers their mouse over different parts of the visualization. Example: The red box in the image below shows the tooltip. It appears as soon as the user hovers his mouse in parts of the visualization and disappears/changes as soon as the user …
Introduction Conditional formatting is a feature in power BI and Excel, that allows you to apply formatting to cells or data based on specific conditions or criteria. The formatting changes are automatically applied when the data meets the specified conditions. It is mostly used in tables and matrix. Prerequisite : Power Bi Types Of Conditional …
Introduction In SQL , sometimes it is needed to use Single Quote in Strings and it comes rather confusing for new users in managing that ordeal.In this article we will focus on how can we use single quote in strings. How to escape single quote (‘) ? In SQL, if you want to use single …
Introductiuon In SQL, Creating and inserting data is important but maintaining databases are also important. Sometimes user are not happy with the current name of the table and wants to rename them according to needs. CAUTION : Before committing to any change, user should double check that renaming the table will not make or break …
