Are pie charts evil? Given the correct situation, pie charts can be used to your advantage in telling your data story. The following case study uses Power BI samples to review examples and provide recommendations to get the most out of an often misused visualization in Excel or Power BI.
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.
I was looking for inspiration and some new ideas for dashboards. What better way than finding inspiring examples of BI solutions from others. The following are some of the go-to links that I am certain you can find useful.
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.