Not all data is shown in visualization

[Moritz360]

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?

[BA_Pete]

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