One beauty of Power BI is the capability of being dynamic. With Power BI Desktop, there are many functionalities that can enable the dynamic report
Category: BI Solution
Requirements: In some situation, business user particularly like a card to display a number of KPI, such as Total Sales, Average Sales per Product, etc.
Ranking is a common but tricky function in Power BI, especially when it comes to “dynamic ranking”. Requirement: Rank resellers in a table based on
Create a dynamic time range for forecasting Acquisition count in a certain mount of days, based on users’ selection. Solution: 1.Calculate the number of days
Do you still remember the excitement when you first wrote a DAX function that produce the correct calculation? Do you also remember the frustration when
Opening Storytelling is proved to be the most powerful way for influencing. The key to success for a storytelling is Effectiveness. As management consultants, you
Summary When you’re sure there is no blanks in your dimension data but still see blanks in your visuals, chances are, you have an invalid