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 valu...
Need Help
  • 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!