Data Analysis Tutorials
In this article, we will show you how to solve the error “A table of multiple values was supplied where a single value was expected” in Power BI. We have created some example data to help explain why this error occurs when you are writing DAX functions and to demonstrate three ways you can resolve … Read more
In this article, we show you how to check for numbers in Power Query and Power BI, as well as how to use the IsNumber DAX function. Power Query does not have an IsNumber function, but we have a way to mimic it. Power BI does have an IsNumber function, but it is not always … Read more
In this article, we will show you how you can check for dates in Power Query and Power BI. You may be used to using functions such as IsDate to check for dates in other languages, however Power Query and BI don’t have an IsDate function. Nevertheless, it is still possible to check for date … Read more
ln this article we will show you how to check for blank values and nulls in Power BI. We cover how to use the ISBLANK DAX function, but also provide a second solution if you need it. IsNull in Power BI The IsNull function does not exist in Power BI DAX. Therefore it can’t be … Read more
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