[PowerBi][UX] Messages explaining visuals - Overlap technique
I know this practice for a long time, and I haven't used a lot until a month ago when a user helped me understand the importance of explaining the blank for their experience. Usually when I use to had blank visual, I didn't do anything about it because I was assuming it was obvious. If you filter data and the visual stays blank, it's because you don't have something the see there. It sounds obvious but many people not related with Bi tools assume there is a failure or issue with the development, and they don't think about a data issue. That's one of many reasons why we need to know this practice of showing a message explaining different situations when that happen. Let's help the users experience and issues perceptions. At the end of the post, we might have even more ideas to develop.Income Statement Analysis: Part 1 of 5
In this 5 part series, we walk through the steps required to build out the first page of the Income Statement Report here. The topics covered in these walkthroughs include: - Part 1: Connecting to Data (Folder Containing CSVs), Importing into Power BI - Part 2: Creating the base measures and an Income Statement Matrix visual - Part 3: Adding advanced measures e.g. based on the period selection (covering use of disconnected parameter tables) and variances - Part 4: Adding KPI cards and Waterfall charts with dynamic axis/Arrow performance indicators and measures to identify good/bad performance for advanced conditional formatting - Part 5: Creation of a fixed format Income Statement (With running total measures) and creation of bookmarks to switch between the income statement formatsBreaking Ties in Rankings with RANKX Using Multiple Columns
There are situations in which you want to use a ranking of rows based on one column, but that column has non-unique values. Sometimes, there are other columns you want to use, if two rows have the same value in the primary ranking column. In this blog, I want to explain step by step how ranking based on multiple columns (more than 2!) can help you solve this problem in DAX. The pattern used is something I picked up in this community, the focus in this blog is on the inner workings of that pattern.
Dynamically Compare the Value of Two Periods
We can use measures to have an easy comparison on the value of today and yesterday, current month and last month. However, it isn’t easy when we encounter below situations: If you need to compare the values of 2020 and last year at this time, but next time you need to compare the values of 2020 and 2018, you need to modify all measures that contain Year, or recreate these measures. When we have 100 measures, it will be a tedious work. If you need to compare two periods that might have a different number of days, like comparing one month against a full year. Filter will be fixed in the formula and cannot be dynamically controlled by the slicer. I will show you two ways to dynamically compare the value of two periods by slicer.Create dynamic chart to show last data based on date granularity
When creating Power BI reports, a very common requirement is to apply filters for a certain day, month, quarter or year. Here I will show how to create a report that allows us to dynamically display data at any date granularity required.Use DAX to create a calendar table with holidays
When calculating in the date dimension, sometimes we only want to calculate the Data in workday. In that case, we will need to get rid of holidays or weekends. This blog will show you how to create a calendar table and mark the holidays, weekends and workday.
