I tried your workaround but it doesn't work for me. I changed the visual to pie chart, went to filters and ticked all the variables besides blank. Then I got back to slice but blank still appear..
I have 10 data tables with product information, demand qty and period. those are related with keydata columns created from product and period information. I used many to one relationsships between the files.
I use several slicers and all of them are showing blanks, while none of the tables containing blanks.
Moreover in the visuals (charts) also there are blanks and the columns in the visual are showing totally wrong numbers compared to source files.
I figured out that the sum of the blank columns and the value columns would be the correct numbers. So, I think, there must be a something with data relations.
this might apply for the slicer blanks as well
Hi, I want to replace my blanks into word "Blanks" so that I can show them in the slicer as blanks itself as one line item, is it possible ??
I have list of word in the 1st column
Thank you in advance
hmm..I wonder what the PowerBI team is doing if they are not even looking at the feedback. This is a very visible and simple problem for two years and still not fixed. How can we trust any MS products?