Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
I am bringing columns from different tables into a table visual. I have applied a page filter on one column and I have also selected to show items with no data.
I bring one of the above columns into a slicer visual. It shows the values available in the column of the table visual but it does not show the option of no-value when there are fields in the table visual that have no value.
Can you advise please how to fix that?
Thanks
Hi @UsePowerBI ,
Like this?
Maybe your filter has filtered out this value in the slicer.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@UsePowerBI , slicer should show blank value in the slicer.
In case you want to replace blank with something, then try
new column = coalesce([column],"No Value")
Proud to be a Super User!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |