Getting rid of white spaces in Matrix and gaps in clustered bar chart

[walker8888]

Hey, so I have a clustered and matrix chart. In my clustered chart, anything that is showing 0% and below I am filtering it out and not showing it. The problem with this is that I now have a gap between my bars. I want to close this gap but have been having a hard time doing so. Is there a trick to this? Also on the same page I have a Matrix chart and that is going perfect, except that I have a lot of white space in some of them due to there not being enough wording I guess. Can this be fixed? Thanks for your help in advance.

[lukiz84]

It's very strange, are you able to share your pbix file?

BR

[walker8888]

I am not able to through here? Can you do email?

[lukiz84]

You have to return BLANK() in your Measures for zero values, then they won't show up. Maybe you could share the DAX code for your measures?

[walker8888]

This is my measure code

Device_Software_Measure =

DIVIDE (

CALCULATE (

SUM ( 'gDS_C3'[Value] ),

FILTER (

ALLSELECTED ( 'gDS_C3' ),

[Attribute] = MAX ( 'gDS_C3'[Attribute] )

&& [Priority] = MAX ( 'gDS_C3'[Priority] )

)

),

CALCULATE (

SUM ( 'gDS_C3'[Value] ),

FILTER ( ALLSELECTED ( 'gDS_C3' ), [Attribute] = MAX ( 'gDS_C3'[Attribute] ) )

)

)

[lukiz84]

ok, please try:

Device_Software_Measure =
VAR result = 
DIVIDE (
CALCULATE (
SUM ( 'gDS_C3'[Value] ),
FILTER (
ALLSELECTED ( 'gDS_C3' ),
[Attribute] = MAX ( 'gDS_C3'[Attribute] )
&& [Priority] = MAX ( 'gDS_C3'[Priority] )
)
),
CALCULATE (
SUM ( 'gDS_C3'[Value] ),
FILTER ( ALLSELECTED ( 'gDS_C3' ), [Attribute] = MAX ( 'gDS_C3'[Attribute] ) )
)
)

RETURN IF(result <> 0, result)

[walker8888]

Thanks but still gives me that gap 

[lukiz84]

please try to set a filter on the chart, add the measure to the filters and set "is not blank"

[walker8888]

I think we are almost there. When I do this it still gives me a gap. I think I may be doing something wrong. 

[lukiz84]

Hi,

thats odd, when i filter Attribute to External FTE's % it works, but I think PowerBI does always shows the blank rows when in any other Attribute (Internal FTE's %) there are numbers. I'm sorry, it seems I can't help you out on this one 😞