Forum Discussion

majid_75's avatar
majid_75
Helper I
6 years ago
Solved

Display axe with a table custom

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

 

Need Help

3 Replies