Data Analysis Tutorials
In this article, we will show you how to send an item to the back or front of your Power BI report. If you are having issues with ‘send to back’ in Power BI, we also cover solutions using the ‘selection’ pane and ‘maintain layer order’ options. Power BI send to back In Power BI … Read more
In this article, we go into detail on the CONCATENATEX DAX function in Power BI and show you how to use it with multiple columns. If you’re looking for a simple way to concatenate columns in Power BI, we have also covered this in a separate post. What is the difference between CONCATENATE and CONCATENATEX … Read more
In this article we will show you how you can concatenate columns in your Power BI tables. We also go over how to concatenate multiple columns using DAX in power BI and how to include spaces. If you’re looking to combine text values across different tables or customize the order of your concatenated strings, you … Read more
In this article, we will show you how to fix the error “We cannot convert the value null to type Logical” in Power BI. You can experience this error in Power Query, which can look like this in one of your applied steps: Or, you may discover it after you have clicked ‘Close and Apply’ … Read more
In this article, we will share a method on how you can bold and underline text in your DAX measures in Power BI. It involves using HTML code in your DAX measure, which enables underlining, bolding, italics and more. Install HTML Content visual The first step you need to take to bold and underline text … Read more
In this article we will show you two ways you can create an information button in Power BI. Information buttons are useful to give an explanation of a visual or page on your report. We will show you two different ways to add them in Power BI. The first method uses a tooltip and a … Read more
In this article we will show you a quick and easy way to group your data into ranges or bands in Power BI. This can be useful if you want to create visuals such as pie charts or bar charts and include the bands in these. Follow the two steps below to add banding to … Read more
In this article, we show you how to create a button to clear all filters with one click in Power BI. There are two methods to achieve this. The first method has been made available recently from a Power BI update and is a very simple way to add a button to clear all filters. … Read more
In this article, we will show you two methods of calculating the number of working days between two dates in Power BI. The first method is to use the NETWORKDAYS DAX function and a table to exclude public holidays. The second method uses a calendar table with your public holidays table and the DATESBETWEEN DAX … Read more
In this article we will show you how to calculate the difference between dates and times in Power Query. We include how to count the number of days, months and hours between two dates or from today, as well as the number of hours between two times. If you want to know how to calculate … Read more