Forum Discussion

La_Brocante's avatar
La_Brocante
Frequent Visitor
2 years ago

Need help to create a grouped bar chart over date

Hi !  I'm discovering Power BI and can't find a way to translate my excel graph to Power BI. I have a table with this kind of values Issue Number Created on Solved on Topic I240701 04/05/...
Need Help
Tutorial Requests
VN999's avatar
VN999
Icon for Resolver I rankResolver I
2 years ago

Create below measure and check it works for your requirement or not ?

IssuesOpened = COUNTROWS(FILTER('YourTable', NOT(ISBLANK('YourTable'[Created on]))))

IssuesSolved = COUNTROWS(FILTER('YourTable', NOT(ISBLANK('YourTable'[Solved on]))))

Replace with YourTable in above measure.