Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Why this graph does not work?

Hello

 

I have the data:

 

A, [blank]

A, 1

A, 2

B, [blank]

etc

 

I want to create a bar graph where the x axis is A, B etc and the y axis is the SUM of all A, B etc values (e.g. for A it is [blank] + 1 + 2).

Please note that the Col2 (i.e. [blank], 1, 2 etc) are results of a MEASURE.

I create the graph visual, I drag the Col1 to the Axis and then I drag the MEASURE in the VALUES but nothing is shown.

 

What is wrong please?

Need Help

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Hi Anonymous ,

     

    When you refer that the values in column 1 is [blank] do you mean you have that text written on the column or simply the column as no values like this:

    A,

    A, 1

    A, 2

    B,

     

    If you have text in the column this will consider the format of the column as text so no calculations are made and you cannot sum values with text. What you need to do is to replace the [blank] with null value on the query editor and then you can sum the values.

     

    If the column doesn't have values written or presents null make sure your column format is set to number.

     

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    HI  Anonymous 

    First, you should make sure that column2 is a number type, if it is no-number type and you use sum for it, there will be an error in the visual.

    Could you please share your sample pbix file for us have a test?  that will be a great help.

     

    Regards,

    Lin