X-axis not showing blanks

[id013]

Hi,

So I have two clustered bar visuals, both show a percentage measure. However one shows a blank space to show where the fiscal period of P07 had a blank value whereas the other just doesn't show the period at all. 

What I'm confused about is that in the bottom visual (pink bars), the numerator is blank for P07 but the denominator is not. And in the Top visual (multi colored bars), the numerator is also blank but the denominator is not. So how come one graph shows a blank but the other doesn't? The only difference I can find is the for the bottom visual, both the numerator and the denominator are sum measures (ie. CALCULATE(SUM etc), and the top visual both the numerator and the denominator are count measures (ie. CALCULATE(DISTINCTCOUNT etc). 

Is there something simple I'm missing here as to why the top visual doesn't show blanks on the x-axis and the bottom one does?

Thanks

[amitchandak]

@id013 , Depend on how you have handled the calculation. Need to know both the values. The best way is use divide with alternate value for A/B = divide(A,B,0) . This will handle divide by 0 and can give 0 in such case.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[id013]

So I think I figured it out, the graph that shows a blank, has the following formula for the numerator, CALCULATE(SUM(sales)) and the graph that doesn't show a blank has the following formula for the numerator CALCULATE(DISTINCTCOUNT(order_id)). I think a sum even if there's no values for the period will return a 0 but a count will return a blank. Does that sound right? 

[Anonymous · Accepted solution]

Hi @id013 

Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[id013]

I should also note that for both percent measures, I'm using the same DAX formula --> DIVIDE(Numerator, Denominator, 0)