Forum Discussion
Solved
[Help] How to create zero count rows in matrix and chart?
Hello Power BI community, I have Ticket table with 3 columns, "Component", "Status" and "Week Number". And I created a matrix in Power BI to show number of tickets(count rows) based on ...
Hi RinJ17,
You can try this:
1) Create 2 new tables and link them with your main one.
Components = DISTINCT ( data[Component] ) Weeks = DISTINCT ( data[Week Number] )2) Create a measure.
Counter = COUNT ( data[Week Number] ) + 03) Use the newly created tables and measure in the matrix visual:
Best Regards,
Alexander
Hi RinJ17,
You can try this:
1) Create 2 new tables and link them with your main one.
Components = DISTINCT ( data[Component] )
Weeks = DISTINCT ( data[Week Number] )
2) Create a measure.
Counter = COUNT ( data[Week Number] ) + 0
3) Use the newly created tables and measure in the matrix visual:
Best Regards,
Alexander
