Expand Rows
Sometimes you want to be able to plan values on a combination of keys that don't have a existing combination in your fact table. This is common i. e. when you have outcomes only on specific months but want to be able to plan on all months, or if you want to add an attribute, such as a new product. You may then experience that some of your cells get a chequered pattern as there are no underlying rows for these cells to store data on. You can read more about that here.
There are many different ways to get Power BI to return rows for each cell. For a small use case, Show items with no data might suffice. Other times, you may want to create a measure that controls which rows are shown or not.
When you want to add rows to your visual we consider it best practice to:
- Create a measure that controls which rows are shown. This gives greater control and is easier to modify than Show items with no data.
- Use one measure to limit/expand your rows for each visual. As you have to alter your CurrentUserKey measure not to expand all dimension combinations, you should always use your limitation/expansion-measure as your Aimplan User Key, having it generate the CurrentUserKey value.
Your measure could look something like this: