Display axe with a table custom

[majid_75]

Hello!!

I have a issue, help please!!

I want to display a custom axis in an X-axis graph.

So I created a table with the different data of my axis, I created a measurement to display my data in the basket but I can’t do it in dax. If someone has an idea...

Here’s what I want

I have a table:

here my measure :

Mesure 2 =

Var x=[Selected KPI]

return

SWITCH(TRUE();

x<0; "<€0"; AND(x>=0; x<100000);

"<€100K"; AND(x>=100000; x<1000000);

"€100K-€1M"; AND(x>=1000000; x<7500000); "€1M-€7.5M"; AND(x>=7500000; x<10000000); "€7.5M-€10M"; ">€10M" )

Can you help me pls!

Thanks

[Pragati11]

Hi @majid_75 ,

You have to convert your measure to a Calculated column in-order to use it on x-axis on the chart.

You can't use a measure on axis with text values.

Thanks,

Pragati

[majid_75]

I have a table with my bucket (not related).

Here, i have this test

i want my NBI  with my bucket "€1M-€7,5M".

And then to do with a chart

[v-lili6-msft · Accepted solution]

hi @majid_75 

For your case, you could refer to this blog:

https://powerpivotpro.com/2015/03/creating-a-histogram-with-a-user-defined-number-of-buckets/

If you still have the problem, please share some sample data and your expected output.

Regards,

Lin