I have a workbook that has blended data sources. I tried to use non-blended as much as humanly possible so I can show the empty rows because I have 3 worksheet tabs that feed one view. Tab one is a table that shows prior month versus current month counts. Tab two is the difference between the two. Tab three is a rolling 13 month graph. Put them together on the dashboard. Everything lines up perfect. If the source is not blended I can saw show the empty rows. I have filters for product, funding, and bed type. The end-user can go through the filters just fine and everything lines up great.
But, the blended data sources do not line up because the show empty rows is greyed out and that is because the data is blended. Tableau turned this off for some odd reason. Does anyone know a work-around for this? The reason for mis-alignment when you cannot show the empty rows is because:
filter market may18 jun18 change jun17 jul17 aug17 sep17 oct17 nov17 dec17 jan18 feb18 mar18 apr18 may18 jun18
PPO CA 10 15 5 2 4 7 12 12 16 15 10 9 5 9 10 15
HMO GA 7 15 22 8 5 3
This example you see that GA has nothing from Dec17 on. The filter is set to all and everything aligns. Filter on PPO and still fine. Filter on HMO and fine. Filter on POS and the alignment goes awry but not because GA does not have a POS. It's because the numbers change when filtering on POS and their jun17 has 2 and jul17 has 4. The rest of the rolling 13 months' is blank because they have no POS numbers after jul17.
I cannot share a workbook since I am talking health insurance here and there are PHI laws we have to follow. I am just hoping that someone has found a work-around for the show empty rows and has run into this with the blended data issue.