Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Greetings,
I am a fairly new user to Power BI (about 6+ months) and I am at a crossroad. In playing around with Power BI, I have learned how to order my matrix to match my fiscal year AND how to add zeros to a blank entry in a matrix. What I have not been able to do is find a way to display both of these at the same time. I can create a matrix sorted nicely or with zeros (dashes) but not both:
I found how to do the sort trick (which works great) and it is utilized by creating two new columns in my data table:
AND
The replace zeros measure I am using is:
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |