Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a question about using slicers in my report.
I make slicer which show the two years, I have just two values in my year table.
But I also see blank value , is it possible to hide this one ?
Thanks for your time
GGR
Solved! Go to Solution.
@adamgor A work around I use quite often is to start with a visual that allows you to filter the value, select/exclude the blank, then change the visual to a slicer and the blank should be gone.
This is not solved.
A (blank) shows up in the slicer, no matter what data it is connected to.
It seems lika a bug. The workaround is not helpful (anymore?).
Did anyone submit this as a ticket?
Though it is not quite an error, but there should be a table relationship related option to choose whether to show blanks or not.
Hi,
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
I believe the "HierarchySlicer" also removes the blanks automatically, and gives you the option to "show items with no data" at the Fields level should you need the blanks
Hi,
I went to investigate and found that the company that developed this (in many ways rather excellent) custom visual still has "ragged hierarchy" (which means that "empties" are not displaid) on their development list. I hope they get to it soon, or that MS makes this visual standard with a few enhancements.
Another great way to deal with this is using the custom visual "Chicklet Slicers" by Microsoft. I had this slicer issue - mine included not only blanks, but also other records represented in the slicer that had a null or zero value for the measure I was hoping to filter them by. Using the chicklet slicer, the report not only looks better, but easily filtered out the records in the slicer that did not have a value by dragging the measure I was using into the data field of the slicer visual.
Thanks you @bourquejeff was struggling to find a way around that one that didn't involve a Page Filter......
I was experiencing this same issue with a very simple table (Hour). The data source did not have any null values, nor did the table that had a relationship with the Hour table, but the Blank() would still show in the slicer.
The fix to this issue for my situation was to check the "Assume Referential Integrity" box from within the relationship between the two tables. This will make the relationship an "inner join" eliminating the Blank().
Referential Integrity is not working in Power bi.
I also have "(Blank)" showing up. But there are no records with blank so the "filter" workaround isn't working. So I'll ask again - why is there a "(Blank)" in the slicer?
Even though "Blank" is not showing up on other visualizations, uncheck "Select All" and select only the items you want. This will fix your problem.
It does not! (Blank) still appears.
It is an ennoying bug. Please vote here :
I used an "is not blank" filter and now "(Blank)" is banished.
@GGR You can filter data while importing using query to exclude blank values. But you won't be able to see associated records with blank value. OR you can rename the blank values to some meaningful name by creating a calculated column. Hope this helps!
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
column1
Apple
Bag
Car
<- Blank
Echo
Expecting Output:
column
Apple
Bag
Car
(Blank)
Echo
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?
I have data that has 0 blank values, yet I still see (Blank) on many of my slicers
Any way to fix this?
@adamgor A work around I use quite often is to start with a visual that allows you to filter the value, select/exclude the blank, then change the visual to a slicer and the blank should be gone.
@Seth_C_Bauer I have created a Table with all the slicer values and have filtered out the Blank value and converted that to Slicer. However, the problem wasn't fixed and I could see the Blank value. Could you help me with this issue. Thank you.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
86 | |
67 | |
49 |
User | Count |
---|---|
134 | |
113 | |
100 | |
68 | |
67 |