Posts:
Power BI – Remove Columns and Remove Other Columns
By: David Rohlfs Introduction Effectively shaping your data is essential in Power BI, and two of the most valuable tools for this purpose are Remove Columns and Remove Other Columns. These features empower you to refine your datasets by removing fields... (more...)
Power BI – Text Box Dynamic Values
By: David Rohlfs Introduction In today’s fast-paced world of data visualization, making your Power BI reports interactive and insightful is more important than ever. One exciting new feature is the ability to incorporate dynamic values into text boxes.... (more...)
Power BI – Extract Tables Using Examples
By: David Rohlfs Introduction Whether you are working with cumbersome CSV files or simply want to streamline your ETL process, the Extract Tables Using Examples function in Power BI can be incredibly useful. This function allows you to use an example... (more...)
Power BI – Cleaning Data by Fill Down and Remove Alternate Rows
By: David Rohlfs Introduction It is almost inevitable that when you connect to a new data set you will need to clean the data before being able to report. There are always test rows, misspelled values, and sometimes just table formatting issues. It isn’t... (more...)
Power BI – Organizing your Measures
By: David Rohlfs Introduction Looking to build your Best Practice knowledge in Power BI? I do a lot of Power BI reports and something that almost always comes up when taking over a report is duplicated measures because of disorganization! In this blog... (more...)
Power BI – Connecting Power BI to Exchange (Outlook)
By: David Rohlfs Introduction Monitoring many email addresses or working in an industry with lots of security concerns? Connecting to Exchange through Power BI means that you can monitor your accounts activity through a Power BI Report! In this blog we... (more...)
Power BI – Pivot in Power Query
By: David Rohlfs Introduction Power Query can be hard and difficult to know what function to use and where to use it. While looking through the Microsoft Power BI and Fabric community forum I came across a question that described a situation where the... (more...)
Power BI – Filtering Out Numbers in a Text Column
By: David Rohlfs Introduction Recently I came across a scenario where I wanted to exclude rows that had a number value in a text-based column. The goal was to do this as a Power BI Filter on the report page because this scenario was specific to this page.... (more...)
Power BI – Changing Data Types in Power BI
By: David Rohlfs Introduction Microsoft has overbuilt Power BI. This is evident with all of the background processes, but also with how the functions are in multiple places all over the system. A great example of this is the many ways that you can change... (more...)
Power BI – Formatting Column Headers in a Matrix Visual in Power BI
By: David Rohlfs Introduction Recently I came across a scenario where I wanted to have conditional formatting on a column header for a matrix visual in Power BI. When working through this I quickly realized that this is not such a simple problem, and... (more...)