I have previously explained that we have three scopes of filtering in the Power BI visualization. The filter created in the filter pane can be often changed or viewed by the user. However, there is a simple way to hide or lock it from the user. In this article and video, I explain how that Read more about Power BI Visualization Tip: Hide or Lock the Filter for Users[…]
If you have a Power BI file for a while, you realize the model gets bigger and bigger. Not only the file size but also the number of pages, tables, fields. You will get to some steps that it would be really hard to find which tables and fields are useful and which are not. Read more about Power BI File Clean-up In a Few Steps[…]
If you build a report for an enterprise, you might be limited to use the organization-approved colors. It is also useful to have your reports following a template of colors, and fonts, which might look like your signature of the report. In Power BI, you can do that with Theme. In this article, I’ll explain Read more about Power BI Theme: Customize Colors, Fonts, and Visual Appearance for Multiple Objects[…]
For a visualization tool, one of the important factors is to filter the data for a specific reporting requirement. Power BI gives you this ability by the Filters pane in the visualization. There are, however, three scopes of filtering, which you need to be aware of. In this short article and video, I explained how Read more about Scope of Filter in Power BI Report[…]
When applying text transformations in Power BI using Power Query; two very important transformations that can help are; Trim and Clean. These two mistakenly often considered to do one thing, but they are different. In this short article and video, I’ll explain their differences through an example. Video Sample text Let’s assume I have a Read more about Trim Vs. Clean in Power BI and Power Query[…]
There are many useful transformations in Power Query for Power BI. One of them is adding the prefix and suffix to a text column. These transformations are very simple to apply and have an immense value in building columns based on patterns and template texts. In this short video and article, I’ll explain how you Read more about Add Prefix and Suffix to a Text in Power BI: Generate Country Images and pages[…]
Power BI has the built-in feature of creating binning for a numeric field such as age. However, the default binning will create bins of equal size. If you want to create bins of different sizes, then you need to create that as a custom column. Fortunately, Power Query has transformations that can help. In this Read more about Create Customized Age Bins (or Groups) in Power BI[…]
There are multiple functions that can help when you work with tables that are connected through relationships. One of these functions is Relatedtable. This function gives you the subtable from the other table for all the rows related to the current row. For example, all sales transactions (from the Sales table) for the current customer Read more about Power BI DAX RelatedTable Function: Get the subtable related to the current row[…]
When you have blank values in your data table, you can use Power Query transformations to remove the row with blank values. There are two transformations that are used very often for this purpose: Remove Empty and Remove blank rows. These two transformations are not exactly the same. In this article, I’ll explain what is Read more about Row Filtering in Power BI and Power Query: Remove Blank Rows Vs. Remove Empty[…]
Sometimes you just need a new table with a few rows or columns to be added to your data model. One option to create that table is to use the Enter Data option in Power BI Desktop. In this article, I’ll explain how you can use it, and also; more important: How to edit the Read more about Create a Table in Power BI using Enter Data, and How to Edit it[…]