Forum Discussion

Moritz360's avatar
Moritz360
New Member
3 years ago

Not all data is shown in visualization

My issue is that after transforming and applying the data when i make visualization with categorical variables some categories dissapear. they are not shown in the visualisation, but are in the rawdata. how can i make them visual?

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi Moritz360 ,

     

    I assume you are using a measure in your visual and the categorie that disappear have zero values. If so, then just add '+ 0' to the end of you measure calculation, like this:

    _sales = SUM(yourTable[Sales]) + 0

     

    Pete