Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Graphs

when a garph is not data, how to remove the axis labels in powerbi.

Can anyone please help me with this

  • Anonymous's avatar
    Anonymous
    2 years ago

    I think i got the solution for my specific case:

     

     

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I think i got the solution for my specific case:

     

     

    • ChiragGarg2512's avatar
      ChiragGarg2512
      Solution Sage

      Anonymous , Do put the dax expression and mark it as solution if anyone encounter the same problem/doubt.

      • Anonymous's avatar
        Anonymous
        Not applicable

        ChiragGarg2512  i have used the advanced function available in text in axis and it worked for my requirement

         

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    remove from filter visual options

  • The axis labels are not dynamic. If the requirement is to remove the labels all together, go to format visual -> X-axis/Y-axis -> Title(off).

    • Anonymous's avatar
      Anonymous
      Not applicable

      in this section only, i found one obtion conditional fomat obtion below:


      how can i use measure in the below section in powerbi, suppose i am creating any measure which will count the the rows, and if rows are blank it will show blank and titile will be shown in white colour and if row have data the then measure color will be black

       

      CaptainCowell  can you please look into it, i think you can help me in this

      • ChiragGarg2512's avatar
        ChiragGarg2512
        Solution Sage

        Yes, that will work. That is great catch.

        1) Need to create a measure that will count the number of rows in the data. [measure]

        2) Another measure that will work on switch function. 

            For Ex., measure1 = switch([measure], 0, "White")

        3) Apply this to conditional formatting in X-axis. {Field value -> Select [measure]}

         

        That is great observation. Nice work Anonymous 

    • Anonymous's avatar
      Anonymous
      Not applicable

      ok if graph axis is not dynamic like i have specific requirement to remove the axis label, when i am selecting any  filter and not showing any data, which visual is best in this situation

      • ChiragGarg2512's avatar
        ChiragGarg2512
        Solution Sage

        It depends on the output data type. If the output is continous over time, a line visual works. If its going to be just a text/numeric value card visual is great. For comparing value for different categories clustered column chart works well.