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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

How to make values in visualization/visualizing that start on 0, 10, 15, 20, 25, 30

Hi All!

 

I need a little help with visualizaing my report. Is there any way to make my y-axis values start on 0, 10, 15, 20.... so on?

Please help me with this.

 

Regards,

lee

 

 

1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous,

 

Because there is no data given I'm not sure if I have understood your problem correctly or not, But I'm assuming that you have a column with either decimal or Whole number from 0 to 20 and you want to visualize the data by using 0,10,15,20...... on y axis.

 

to achieve this make a new column

 

Interval =
IF (
    number >= 0
        && number < 10,
    "0",
    IF (
        number >= 10
            && number < 15,
        "10",
        IF ( number >= 15 && number < 20"20"BLANK () )
    )
)

 

 

Use this column in y-axis .

 

Regards,

Gaurav Raj Singh

 

                     

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.