# Data's are not populating when click on Bar or Line or Pie chart

**URL:** <https://community.eazybi.com/t/datas-are-not-populating-when-click-on-bar-or-line-or-pie-chart/1796>\
**Category:** Questions & Answers\
**Created:** [February 28, 2019, 11:52am UTC](https://community.eazybi.com/t/datas-are-not-populating-when-click-on-bar-or-line-or-pie-chart/1796 "2019-02-28T11:52:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vignesh\_b.s](https://community.eazybi.com/letter_avatar_proxy/v4/letter/v/e56c9b/32.png) [@vignesh\_b.s](https://community.eazybi.com/u/vignesh_b.s)\
**Post date:** [February 28, 2019, 11:52am UTC](https://community.eazybi.com/t/datas-are-not-populating-when-click-on-bar-or-line-or-pie-chart/1796/1 "2019-02-28T11:52:38Z")

</div>

HI,

Im creating the report to determine backlog status health for all Groups.

Formula i used = CASE WHEN [Measures].[backlog Story Points] \> ([Measures].[Average sprint velocity for 3 months] \* 3) THEN ‘1000’ WHEN [Measures].[backlog Story Points] \> ([Measures].[Average sprint velocity for 3 months] \* 1) AND [Measures].[backlog Story Points] \< ([Measures].[Average sprint velocity for 3 months] \* 3) THEN ‘500’ WHEN [Measures].[backlog Story Points] \< ([Measures].[Average sprint velocity for 3 months] \* 1) THEN ‘150’ END

Although im getting the expected output for the above formula in Table. But when i click on Bar or Line or Pie chart. Data’s are not getting populated. its just showing empty graph or line or Pie.

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [March 13, 2019, 11:33am UTC](https://community.eazybi.com/t/datas-are-not-populating-when-click-on-bar-or-line-or-pie-chart/1796/2 "2019-03-13T11:33:47Z")

</div>

Hi,

You could try returning integer numbers (instead of “string”) in your calculation which eazyBI would understand as numbers for the chart.  
In your code currently you return string type of values ‘1000’, ‘500’ which can’t be vizualized on a chart.

Try the following code:

`CASE WHEN [Measures].[backlog Story Points] > ([Measures].[Average sprint velocity for 3 months] * 3) THEN 1000 WHEN [Measures].[backlog Story Points] > ([Measures].[Average sprint velocity for 3 months] * 1) AND [Measures].[backlog Story Points] < ([Measures].[Average sprint velocity for 3 months] * 3) THEN 500 WHEN [Measures].[backlog Story Points] < ([Measures].[Average sprint velocity for 3 months] * 1) THEN 150 END`

Note that all branches (“Then”) should return the same data format in order to make this work.

Martins / eazyBI support

---

<div class="post-metadata">

**Author:** ![vignesh\_b.s](https://community.eazybi.com/letter_avatar_proxy/v4/letter/v/e56c9b/32.png) [@vignesh\_b.s](https://community.eazybi.com/u/vignesh_b.s)\
**Post date:** [March 18, 2019, 8:55am UTC](https://community.eazybi.com/t/datas-are-not-populating-when-click-on-bar-or-line-or-pie-chart/1796/3 "2019-03-18T08:55:31Z")

</div>

Thanks much martins. You are awesome…