/
Create measures in Power BI to get the issue count based on the labels

Create measures in Power BI to get the issue count based on the labels

Jul 25, 2022

This article explains the steps to get a Power BI report which displays the issue count based on the issue's labels.

Instructions

  1. Log in to Jira and navigate to the global navigation Menu (on the top) → AIO Power BI → My Connector URLs. 
     



  2. Click on Add New Connector.

  3. Input the JQL and select the fields as shown below:



  4. Make sure the JQL returns the expected results in the issue navigator as shown below:

  5. Import the connector into Power BI by navigating to Get Data > OData feed > Basic > Paste URL > provide the credentials > Load the data by selecting tables.

  6. Create a measure in Power BI as shown below, where Measure will get the count of issues containing labels and Measure 2  will get the count of issues that don't contain any labels). Select the fields on the right-hand side to display them on the report.





    Refer to this Power BI documentation https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-measures for creating measures.