Forum Discussion
Post PatronHow to show default values for missing periods
Post Patron
I have provided sample data . Please check once.
sample Data file : https://drive.google.com/file/d/1brZTsnfqx0mTryREYkTrb5PreaC5mO8a/view?usp=sharing
If we filter "B" from the group its will not show 2019-03, 2019-04, 2019-06 values and periods, because in the data it self period was not there for that transaction. So we need to show missing periods with dummy values along with ohter periods.
I hope it's clear to you.
Community Championharib Your issue is that everything is in one table, so when you filter for group B, you lose the Periods not related to B. You need to create a related data model with dimension table for period (each period exactly once).
You can use DAX new Table to do this quickly (what I did for testing) but I prefer to have the dimension tables loaded into the power query.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
- harib
It's almost met my requirement, however i would like to display "0" values for that periods instead of showing blank .
- AllisonKennedy
You could try a measure in that case.
Total value = 0 + sum (value)
Or might need to be sumx depending on how you use it.
- harib
Solved my Problem. Thanks a lot. 😊