Thank you so much for uploading this video. I was in need of this video and none other has come up with the solution like this. Not even tableau community
On my Tableau Desktop 2021.3.8, I tried your recommendation by adding Text over the Sheet on Horizontal Layout. After setting the floating order of sales sheet to 'bring to front', the $0 text is no longer visible, even when no records exists for the filter selection. What is the mistake I'm making ? Please advise.
Please check if you have the transparent background selected for the front layer and also check if you have used square shape mark instead of text mark. Hope that helps.
When I bring technology $554 to front the $0 doesn't show or the #'s didn't even overlap. $0 totally disappeared. What wrong I am doing ? I am using 2021.4.2
Hi Sonia, the "$0" value should only be visible when there is no data and till then it should be sitting behind the $554 layer. When you change the filters and there is no data then $0 should only be visible. Hope that helps 🙂
Hello its very nice to see this post. But in last step when values are overlapping and we convert text as square then that sqaure as a background hiding NA value. Please suggest
Thats a great question. It will work if you have data relevant to that KPI. IF there is no data then then you could show zero value this way but filter action wont work work as there no data. Hope that helps
Hi Max, This is a work around solution that works with floating contains only as we have to use layers thats only possible floating containers. Hope that helps.
Thats a great question Sandeep. Ifnull or ZN function will work when there is data but the measure values are null. In this tutorial I am trying to explain when there are no records in the dashboard or user filters out all the data, then how can we show "zero" value instead of blanks. Hope that answers your question. Please feel free to reach out if you need more information.
Can you please suggest me on same concept but, by using both sheets as tiled in Dashboard??? If this works as in sheets as tiled , It helps me a lot. Thanks in Advance!
Yes, you can now with the latest version of tableau 2022.3 using dynamic zone visibility feature. Please try then and feel free to reach out in case of any issues. Cheers! Gurpreet
Thank you so much for uploading this video. I was in need of this video and none other has come up with the solution like this. Not even tableau community
Appreciate your kind words 🙏
Thanks you for supporting this channel 😊
On my Tableau Desktop 2021.3.8, I tried your recommendation by adding Text over the Sheet on Horizontal Layout. After setting the floating order of sales sheet to 'bring to front', the $0 text is no longer visible, even when no records exists for the filter selection. What is the mistake I'm making ? Please advise.
Please check if you have the transparent background selected for the front layer and also check if you have used square shape mark instead of text mark.
Hope that helps.
Was trying to find a solution to this problem for a long time... many thanks
That’s great Kapil.
Thanks for supporting our channel
When I bring technology $554 to front the $0 doesn't show or the #'s didn't even overlap. $0 totally disappeared. What wrong I am doing ? I am using 2021.4.2
Hi Sonia, the "$0" value should only be visible when there is no data and till then it should be sitting behind the $554 layer. When you change the filters and there is no data then $0 should only be visible. Hope that helps 🙂
I am facing same issue and unable to solve, my null values are not replaced with 0.
Could you please provide more detail and let me know at which step you are facing issue.
@@DataVizCanvas Thank you so much for the reply. Solved that issue, i was making a mistake.Now Solved :)
@@m.arslanakram5832 Glad it worked for you :-) Well done. Cheers!
@@m.arslanakram5832 How did you resolve your issue? I am facing issues with pie chart?
@@m.arslanakram5832
Hello its very nice to see this post.
But in last step when values are overlapping and we convert text as square then that sqaure as a background hiding NA value.
Please suggest
Hi Vinay, I am not clear with your question. Could you please provide more details?
Let say i need to create an action filter by clicking on that number. how will that gonna work?
Thats a great question. It will work if you have data relevant to that KPI. IF there is no data then then you could show zero value this way but filter action wont work work as there no data. Hope that helps
O my god, this solution was so simple !!! thanks
Glad it helped!
Cheers!
Gurpreet
Is there a way to do the same, but with the tiled settings, instead of floating?
Hi Max, This is a work around solution that works with floating contains only as we have to use layers thats only possible floating containers. Hope that helps.
Instead of this why don't we use ifnull function or zn??
Thats a great question Sandeep.
Ifnull or ZN function will work when there is data but the measure values are null. In this tutorial I am trying to explain when there are no records in the dashboard or user filters out all the data, then how can we show "zero" value instead of blanks. Hope that answers your question. Please feel free to reach out if you need more information.
Thanks a ton for this. You are saviour
Glad I was able to help 🙏🏽
Stay tuned for more such tutorials 😊
Thank you so much for sharing this information. This was very helpful!
Glad i was able to help. Thanks for supporting my channel 🙏
Thank you for this tutorial! You helped me overcome the same issue :)
I have the same case where IfNull or ZN function does not work or show 0
Glad it was helpful. Stay tuned for more tips 👍🏽
Wow amazing thank you so much for the tip!
Glad it was helpful. Thanks for supporting my channel Wendy🙂
It was really helpful. Thank you!
Thanks @Keila
Can you please suggest me on same concept but, by using both sheets as tiled in Dashboard??? If this works as in sheets as tiled , It helps me a lot. Thanks in Advance!
Yes, you can now with the latest version of tableau 2022.3 using dynamic zone visibility feature.
Please try then and feel free to reach out in case of any issues.
Cheers!
Gurpreet
Hi. How to hide worksheet title too?
You can do that by clicking on the dropdown on the top right corner of the sheet and hide the title.
Great job on this!
Thanks 🙏
how to avoid blank screen on dashboard while all filter deselect it is possible?
I am not clear with your question. Could you please provide more details.
Thank you.
You are welcome 🙏
the floating sizing will fcked up when it is being display in a big TV
Thats correct. This technique is useful with standard screen size.
Excelent! ;)
Thanks 🙏
How would you do this with a bar chart?