How can I do this when there is no order date for the month after? Ie if I have data up to november, but no data with order date in december, is it possible to show december?
Hi Cooper, If there is no record/data for December for any dimension value then it’s not possible. You need to have at least on record in the dimension value and when u filter that dimension, if there are no record for other dimension value then u can use this method shown in the tutorial. Hope that helps
@@DataVizCanvas I actually figured a workaround. I created an excel sheet with one column called month name, and added each date for all 12 months (1/1/2021, 2/1/2021 etc) and did a join with my original data and month data and was able to get it to show later months
Try using Tableau relationship data model. That will help you to cover such scenarios. Please check my tutorial on Relationships ua-cam.com/video/ElD8jbnLjaw/v-deo.html
Can you tell me why tableau has limited charts option and power BI has many charts option. I know we can make extra charts with tableau calculations like sankey chart, radar chart etc. But in power bi we can make any chart with one click. And in tableau it is not so. Can you please explain?
I’m not clear what you meant. Are you looking to create a separate bar chart for only missing values? 🤔 if there are no values then there won’t be any bar. Please clarify what you meant by “bar chart for missing values”
@@DataVizCanvas as it is possible to explain my doubt in the comment section, I have dm you on instagram. Please have a look. I have also shared a screenshot
@@zaid6283 Thanks for sharing the details. In your scenario there are no rows in the database for "Copier" and when you select "show Empty rows/columns" that row appears as blank. As there is no data you wont be able to show "0" as text label because there is no reference in the dataset that you could use to show zero. You could show headers for that column to make sure copier is part of that header. Another way to do it to use layers and i have a seperate tutorial on that.. have a look if that helps ua-cam.com/video/HNtrDFpY5_E/v-deo.html And if you figure out any other way to do the same then please share with me and tableau community as well. Thanks :-)
How can I do this when there is no order date for the month after? Ie if I have data up to november, but no data with order date in december, is it possible to show december?
Hi Cooper,
If there is no record/data for December for any dimension value then it’s not possible.
You need to have at least on record in the dimension value and when u filter that dimension, if there are no record for other dimension value then u can use this method shown in the tutorial. Hope that helps
@@DataVizCanvas I actually figured a workaround. I created an excel sheet with one column called month name, and added each date for all 12 months (1/1/2021, 2/1/2021 etc) and did a join with my original data and month data and was able to get it to show later months
That’s great Cooper. Thanks for sharing...Cheers 😊
Thank you! This was so useful!
You are welcome 🙏
Glad you find it useful. Please subscribe and share my channel with wider community so they can benefit from it as well.😊
this is good thanks a lot, however, if i just want to show the null value months only and other side where the sales were done, how that can be done ?
Try using Tableau relationship data model. That will help you to cover such scenarios. Please check my tutorial on Relationships
ua-cam.com/video/ElD8jbnLjaw/v-deo.html
Can you tell me why tableau has limited charts option and power BI has many charts option. I know we can make extra charts with tableau calculations like sankey chart, radar chart etc. But in power bi we can make any chart with one click. And in tableau it is not so. Can you please explain?
:-) Well only Tableau product team can answer that questions ;) You can submit your case to Tableau using below link www.tableau.com/support/case
How can I display a small size bar chart for missing values?
I’m not clear what you meant. Are you looking to create a separate bar chart for only missing values? 🤔 if there are no values then there won’t be any bar. Please clarify what you meant by “bar chart for missing values”
@@DataVizCanvas as it is possible to explain my doubt in the comment section, I have dm you on instagram. Please have a look. I have also shared a screenshot
@@zaid6283 Thanks for sharing the details. In your scenario there are no rows in the database for "Copier" and when you select "show Empty rows/columns" that row appears as blank. As there is no data you wont be able to show "0" as text label because there is no reference in the dataset that you could use to show zero. You could show headers for that column to make sure copier is part of that header.
Another way to do it to use layers and i have a seperate tutorial on that.. have a look if that helps ua-cam.com/video/HNtrDFpY5_E/v-deo.html
And if you figure out any other way to do the same then please share with me and tableau community as well. Thanks :-)
Thank you bro ,How can we display zeros for each missing month ?
You could use a calculation using if null and then drag it to text Mark
Iffnull(sales,0)
@@DataVizCanvas Thanks for your response and sharing wonderfull videos :)
It not showing 0 for no values @@DataVizCanvas
I didn't get the option show empty columns
Could you please provide more details. Thanks