Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply

Graphs

asgar_gormalone_0-1695278442352.png

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

Can anyone please help me with this

1 ACCEPTED SOLUTION

I think i got the solution for my specific case:

asgar_gormalone_0-1695286397669.pngasgar_gormalone_1-1695286426494.png

 

asgar_gormalone_0-1695287847709.png

 

View solution in original post

11 REPLIES 11

I think i got the solution for my specific case:

asgar_gormalone_0-1695286397669.pngasgar_gormalone_1-1695286426494.png

 

asgar_gormalone_0-1695287847709.png

 

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

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

asgar_gormalone_0-1695287804994.png

 

 

 

A measure can be created with if statement also. This can reduce the work getting put into formatting the other values. If statement will return white for blank values and blank for any other values.

Idrissshatila
Super User
Super User

Hello @asgar_gormalone ,

 

Switch the titles off in both x-axis and y-axis.

Idrissshatila_0-1695279529182.png

 

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




ChiragGarg2512
Solution Sage
Solution Sage

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).

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

asgar_gormalone_0-1695280399868.png


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

asgar_gormalone_1-1695280762842.png

 

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

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 @asgar_gormalone 

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

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.

vs_7
Responsive Resident
Responsive Resident

Hi @asgar_gormalone ,

remove from filter visual options

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors