Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi BI Community Team,
I have a sales data and build the matrix table to see the performance for full year 2024 & 2025. However, matrix table layout will change when choose the year because data is not full yet for 2025 as the screenshot below.
Any suggestion/advise how to fixed the layout even data is unavailble? I mean header will be showing Jan | Feb | -- | Dec, and value is zero (0) if unavailable of data.
Expectation result:
Thanks and Regards,
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirment.
Show items with no data in Power BI - Power BI | Microsoft Learn
Hi All,
Thank you for your time and feedback.
Best Regards,
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirment.
Show items with no data in Power BI - Power BI | Microsoft Learn
Hi @ADSL ,
Is there any reason to duplicate the matrix table into separate tables for 2024 and 2025? Why not combine them into a single matrix table to also resolve the issue of missing data?
Best regards,
Hi @DataNinja777 ,
We're tracking by year and selection but just have issue of layout that is changing when select.
I don't have any solution to fixed this layout as the expection result below even year selection is choose.
Hi @ADSL ,
To prevent Power BI matrix visuals from hiding future months with zero or null values, ensure your Calendar table covers the entire desired period, such as all of 2025. Use a measure like:
Sales with Zeros = IF(ISBLANK(SUM(Sales[Amount])), 0, SUM(Sales[Amount]))
This replaces blanks with zero, ensuring months with no data remain visible. Additionally, enable “Show items with no data” by right-clicking the relevant field in the Fields pane.
For a more comprehensive solution, use CROSSJOIN to generate all combinations of months and categories, or create a measure to display zeros for future dates:
Future Sales = IF(MAX('Calendar'[Date]) > TODAY(), 0, [Sales with Zeros])
These steps ensure your matrix visual includes future periods, even if they have no data.
Best regards,
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
70 | |
68 | |
43 | |
34 | |
26 |
User | Count |
---|---|
88 | |
52 | |
45 | |
39 | |
38 |