Power BI Data Visualizations

Being a Power BI enthusiast, I always find DAX a challenge but have found success by keeping to a couple of simple tricks. In this Power BI Tutorial, we review my DAX development workflow through an example case where we will use Power BI Desktop to create a KPI measure

Once you have your data, the next big decision in your Power BI project is how you want to visualize it. The most significant part of the decision process could be the most important; choosing your Power BI color palette and data visualization color combination.

Power BI lacks the ability to add KPI calculations when creating a data model in Power BI Desktop. I will show you how to get the same functionality by using the recently released feature “Conditional Formatting by a Different Field”. This will allow you to take a calculated score and have an Icon displayed for each row in your table.  A working Live Interactive Power BI Sample is attached at the bottom of this post.

I needed to quickly create a calculation that tested for the presence of a string in another column’s text values. There are two ways to solve this, but the first one is an interesting example that you can use in several situations.  This solution plays on the true-false values of the DAX IF function in PowerBI.

PowerBI has the ability to mashup data from different sources; this may introduce problems when joining or matching data between systems. I was able to get around this issue by leveraging an R script from an article in the community. As a consultant there is a rule that if you use something from the community, you need to give back and particularly if you use it twice, you have to write a blog post. This is such a post.

We are all busy and jumping between tasks and projects.  This makes it easy for your accomplishments to get left behind as you move on to the next thing.  Keeping an accomplishment log will help you track what you have completed, your successes and will also serve as a resource for items you can reuse later.