The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |