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 rawdat...
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