Forum Discussion

Microsoft Employee

5 years ago

Show items with no data Paginated Report

Hi All, Any tips to force my matrix to display all my dimension even if my measure is null ? regards

Super User

5 years ago

nkasdali

You can add +0 to your measure though it has some performance impact.

How about if you select "Show Item with No Data" ?

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

Microsoft Employee

5 years ago

hi Fowmy unfortunalty "Show Item with no data" is in the Power BI Desktop, and i'm using Power BI Report Builder.

i'll try your +0 tips 😉

thanks