Forum Discussion

Anne_PBI's avatar
Anne_PBI
Frequent Visitor
1 year ago
Solved

Missing rows

Hi all,   I have a calculated value (calculated in power query, set as decimale value) and it shows the current values per row. Each row is unique. However, when I sum that same value with the sum...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anne_PBI ,

    Please follow the steps below to do and check if it can display the records with blank values:

    1. Select the table visual

    2. Navigate to Fields options, select the category field(like the field [index])

    3. Right click and choose the option "Show items with no data"

    Show items with no data in Power BI - Power BI | Microsoft Learn

    Best Regards