Need Help in creating charts

[Ashish9201]

Hi Team,

Can you please help me in charting charts.

Below sample column chart that i want to create.

I am facing issue as below:

Unable to add the ARPE tiers measure in column of the chart.

Can someone help me on this?

File link: https://we.tl/t-N8A4UGAOpd

Thank you,

Ashish Gupta

[Ashish9201]

Hi @v-yanjiang-msft ,

Can we add them in X axis then?

Regards,

Ashish Gupta

[v-yanjiang-msft]

Hi @Ashish9201 ,

Unfortunately, we can't do that, X-axis need determined values, measures are calculated according to context, they can't be in X-axis. If you stil want to diaplay ARPE tiers and other values in a visual, you'd better use a table or matrix.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish9201]

Hi @v-yanjiang-msft ,

I have already creating matrix for other values.

I am unable to figure out how to represent the ARPE tiers in column of a matrix?

I did tried building a table for ARPE tiers. But since there is no relationship between both the table, the visual gives out error.

Can you please help me out in order to represent ARPE tiers in column of matrix?

Regards,

Ashish Gupta

[Ashish9201]

Hi @v-yanjiang-msft ,

Can you please help me out in order to represent ARPE tiers in column of matrix?

Regards,

Ashish Gupta

[Ashish9201]

Hi All,

Can you please help me out in order to represent ARPE tiers in column of matrix?

Regards,

Ashish Gupta

[Ashish9201]

Hi,

Is there any work around to have them added in Y column of chart?

Have created a dataset which has the tiers but since they do not have any relationship it is giving me error.

Regards,

Ashish Gupta

[v-yanjiang-msft]

Hi @Ashish9201 ,

It's not because relationship, it's a text data, suppose it can be put in the column, it make no sense, the column only represent the size of the value.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yanjiang-msft]

Hi @Ashish9201 ,

For a column or line chart, the Y-axis must be in number format, in this way, the chart can measure its size. In your sample, ARPE tiers measure is in text format, so it can't be put in the column.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.