Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a table visual with job titles and filtered to only show "(L2) Apprentice Level 3, (L3) Apprentice Level 5, (UQ) Apprentice Level 3, Nursery Apprentice Level 2, (L2) Apprentice Level 5, (UQ) Apprentice Level 5". But the values for the below given categories "(L2) Apprentice Level 5, (UQ) Apprentice Level 5" are zero. Hence its not displaying on the table. I want the table to have all selected job titles even if any of this job title has zero value. How to achieve this? Have added a screen shot on the below for more clarity. Kindly help.
Hi
Thank you very much in taking this time in helpig me. But even after changing this it doesn't seems working. Attached the screen shot
Any help on the above pls?
I created a new measure table and built relation with the actual data source column, which helped me to display the selected job titles even if they did not have any values. The below is the DAX measure I used to create a new table:
But now the issue is the table just displays blank when there is no value and I want it to display Zero if its blank. Attaching screen shot for reference.
Any help?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 62 | |
| 46 | |
| 42 | |
| 26 | |
| 18 |
| User | Count |
|---|---|
| 193 | |
| 124 | |
| 101 | |
| 67 | |
| 49 |