# Create a chart with selected labels imported from JIRA

**URL:** <https://community.eazybi.com/t/create-a-chart-with-selected-labels-imported-from-jira/4210>\
**Category:** Questions & Answers\
**Tags:** label\
**Created:** [April 19, 2020, 12:07pm UTC](https://community.eazybi.com/t/create-a-chart-with-selected-labels-imported-from-jira/4210 "2020-04-19T12:07:38Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [April 27, 2020, 10:48am UTC](https://community.eazybi.com/t/create-a-chart-with-selected-labels-imported-from-jira/4210/2 "2020-04-27T10:48:29Z")

</div>

Hi @prai,  
you can add **Label** dimension in [**Pages**](https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Pagedimensions) and use that for filtering your report.

For filtering report for last 5 closed sprints you can use my colleagues trick & trip:

> [@Filter your eazyBI for last 5 closed sprints](https://community.eazybi.com/t/filter-your-eazybi-for-last-5-closed-sprints/2099):
>
> Hi This is an approach on how to filter the report for the last 5 closed sprints if you have other dimensions in pages which makes the report context. You could adjust the code to show more/less than 5 and also switch to show first sprints by changing the ordering conditions. First, you could create a new calculated measure (only to filter last 5 closed sprints sorted by sprint start dates) in your report using this code: Case when [Sprint].Currentmember.Level.Name = 'Sprint' Then Case whe…

Or create [an aggregate member](https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members/calculated-members-in-other-dimensions) in your **Sprint** dimension that will show you last 5 closed sprints:

```
Aggregate({
Tail(
  Order(
    Filter([Sprint].[Sprint].Members,
    [Sprint].CurrentMember.getBoolean("Closed") 
    AND
    NOT IsEmpty([Sprint].CurrentMember.get("Complete date"))
    ),
    [Sprint].CurrentMember.get("Start date"),
    BASC
    ),5
  )
})

```

best,  
Gerda // [support@eazyBI.com](mailto:support@eazyBI.com)

---

_[View the full topic](https://community.eazybi.com/t/create-a-chart-with-selected-labels-imported-from-jira/4210)._