Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Could anyone please guide me,
How to remove the blank option from slicer.
Thanks,
Joshua
Generally this is a data relationship issue.
Hi,
I am using nearly 5 slicers,
but only I am getting this type of issue in one of the two slicers.
Is there any tricks to solve this out?
Thanks,
Joshua
Generally this means that... you either HAVE a blank in your data... or, that you have a relationship... and the lookup table (the 1 side of your 1 to many relationship) doesn't have EVERY value from your fact table (the many side of the relationship).
The easy way to find it is to add a calc column on the fact table, that is =RELATED(LookupTable[SomeColumn]), then look for the BLANK in the new calc column.
@JoshuaTo solve this right away - switch to the Hierarchy Slicer
To find out why/when it happens read here - specifically @OwenAuger's post on page 2
http://community.powerbi.com/t5/Desktop/SLICERS-gt-blank-value/td-p/6726/page/2
(For me it happens in a bit different scenario than the example given by Owen - mine involves 4 tables but same principle)
The way I resolved it in my case (Note - I don't know if this would make sense/apply in yours)
I created a new COLUMN in the "many" table - use RELATED ( One SideTable[SlicerColumn] )
to bring to the "many" table only the values you need - and then use this new column instead for your Slicer
Again please note that this works in my case which is slightly different than Owen's example because
selecting Blank in my slicer results in all charts measures visuals showing nothing
unlike in Owen's example which actually if I recall displays a value when blank was selected in the slicer!
(hope this makes sense)
Good Luck!
Thank you for that tip. I downloaded the Hierarchy Slicer and my problem was solved. The old way of filtering then changing to a slicer no longer works.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |