Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Bad representation in X axis

Hello everybody. I hope all of you are great!

 

I have a visualization that works with this formula:

 

The X axis works great here. But the problem is that what I have to represent is the next formula, and then the X axin adds some especial values that I do not want:

It is soooo strange! The only thing that I need is to invert a % number, from 5 % to 95 % (my boss want it that way), but the X gets completely crazy. Does anybody know how to fix this?

 

(in the X axis, Power BI  does not allow to put it as Logarithmic...)

 

Thanks a lot. Best regards,

 

Chema Ortega

 

Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Hi Anonymous ,

     

    Since you are using a text column for your X-axis the sorting will be accordingly to that.

     

    One additional question on the first visualization (assume is the one that has 5%) you only get the monthly values correct? But when you do the 1- you get the values with the Q correct?

     

    What may be happening is that the value for 2024_Q1 and 2024_Q2 is blank however when you add the 1- to the formulat irt gets the value of one try to change your measure to this:

    Valor de prueba = 
IF( DIVIDE ( [V1 BUENO], [V2 BUENO], 0) <> Blank() ||  DIVIDE ( [V1 BUENO], [V2 BUENO], 0) <> 0 , 
1 - DIVIDE ( [V1 BUENO], [V2 BUENO], 0))

     

    This may need some adjustments

     

4 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous ,

     

    If you are using an hierarchy axis then you just need to turn off concatenate labels:

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Miguel,

       

      No I am not using a hierarchy axis, it is a column from a table with format "202404"... Thanks a lot anyway,

       

      Chema Ortega

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        2 years ago

        Hi Anonymous ,

         

        Since you are using a text column for your X-axis the sorting will be accordingly to that.

         

        One additional question on the first visualization (assume is the one that has 5%) you only get the monthly values correct? But when you do the 1- you get the values with the Q correct?

         

        What may be happening is that the value for 2024_Q1 and 2024_Q2 is blank however when you add the 1- to the formulat irt gets the value of one try to change your measure to this:

        Valor de prueba = 
IF( DIVIDE ( [V1 BUENO], [V2 BUENO], 0) <> Blank() ||  DIVIDE ( [V1 BUENO], [V2 BUENO], 0) <> 0 , 
1 - DIVIDE ( [V1 BUENO], [V2 BUENO], 0))

         

        This may need some adjustments