Column chart not displaying data

[shas]

Hi,

I Have a column chart with 6 measure and 2 dimensions.

out of which 5 are static value meaures and the 6th is a meaure that varies based on a filter.

but when the filter is applied the value goes to zero cetrain case and rest of the 5 measures are not shown when for one dimension the the 6th measure is zero.

i need the 5 measure to be displayed  for both the dimension even when the 6 the measure is zero for one of the dimension.

Thank you!

[Ritaf1983]

Hi @shas 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[shas]

Hi @Ritaf1983 ,

Thank you! for your response. I wont be able to share the data.

but let expand on explaining the question.

The measures i have creater give me %value and i use caterorical column as x-axis

let the categories are A and B.

the measuare user 3 columns of orginal data and a calculated column to genrate this percentage value.

the measure creates the single percent value but when the catgorical value is placed in x-axis the measure calculates the percent value for the two categories. 

this is same for all the 6 measures i have created.

among the six measure there is one measure that will be affected by a slicer which is fixed in other five measure. 

For some selections of the slicer the measure that is affected does not have a value for one of the categories.

then the other five measures which are not affected by the slicer are also not shown.

i am using a cluster column chart.

x-axis is the 2 categorie and y axis  the 6 measures.

Thank You!