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

Question

Hi All!&nbsp;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.&nbsp;Regards,lee&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous,&nbsp;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.&nbsp;to achieve this make a new column&nbsp;Interval&nbsp;=IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;number&nbsp;&gt;=&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;number&nbsp;&lt;&nbsp;10,&nbsp;&nbsp;&nbsp;&nbsp;"0",&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;number&nbsp;&gt;=&nbsp;10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;number&nbsp;&lt;&nbsp;15,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"10",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;number&nbsp;&gt;=&nbsp;15&nbsp;&amp;&amp;&nbsp;number&nbsp;&lt;&nbsp;20,&nbsp;"20",&nbsp;BLANK&nbsp;()&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;))&nbsp;&nbsp;Use this column in y-axis .&nbsp;Regards,Gaurav Raj Singh&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

Forum Discussion

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

1 Reply

Related content

Custom Visual

PowerBI - Matrix table, hide values used only for a visual calculation

Visual

Line Chart Visual Axis Value Display

Table Visual not Matching Calculated Visual