Forum Discussion

sunah132's avatar
sunah132
Icon for Helper I rankHelper I
4 years ago
Solved

matrix data not drilled through

I would like to add customers into the matrix to be able to see customer ID on it but is it possible not to have each price shown like right? I tried "show item with no data" but didn't really make t...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI sunah132,

    Did these records really exist in your tables? If that is the case, I'd like to suggest you enter to the 'query editor' and use 'fill up/down' feature to fill these records with no data.

    Fill values in a column | Microsoft Docs

    If they are not included in your tables, you may need to create a table with all the category types as the visual category, then write DAX expression to expand these records.

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI sunah132,

Did these records really exist in your tables? If that is the case, I'd like to suggest you enter to the 'query editor' and use 'fill up/down' feature to fill these records with no data.

Fill values in a column | Microsoft Docs

If they are not included in your tables, you may need to create a table with all the category types as the visual category, then write DAX expression to expand these records.

Regards,
Xiaoxin Sheng