Forum Discussion

shas's avatar
shas
Frequent Visitor
2 years ago

Column chart not displaying data

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!

Need Help

2 Replies

    • shas's avatar
      shas
      Frequent Visitor
      2 years ago

      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!