Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Show items with no data

Hello, 

 

I want to click on the option show items with no data, but Power Bi doesn't show it as an option. Is it because of the visual, I am using a table?  Is there another way I could only show colour that was condittionnaly formatted without the data showing on the visual ?

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , That option will only come on a column which is text/date and if number then use Don't summarize option in column tools property and then check this option

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, 

     

    I have clicked don't summarize, then do not show items with data but still I've got numbers here. I want to show only the colour with no numbers for a certain column.