Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Line-Chart

Hi Community   I've tried to create a PowerBi report. The Report is connected to a SharePoint-List. The List have a column "status", with two values "new" and "closed". Now I've tried to create a ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi Anonymous,

 

Here I made a sample like this.

 

 

In the sample I created two measures to achieve the goal.

 

Close = CALCULATE(COUNT(Table1[Status]),FILTER(Table1,Table1[Status]="closed"))
new = CALCULATE(COUNT(Table1[Status]),FILTER(Table1,Table1[Status]="new"))

Here is the result for your reference.

 

 

For more details, please check the pbix as attached. If it doesn’t meet your requirement, kindly share you sample data to me.

 

https://www.dropbox.com/s/lba582729qiu74x/Line-Chart2.pbix?dl=0

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Frank

 

Thanks for your solution. For me i think it is not the right one. Because with this measure it just count the actual status (new or closed).

 

- I should have one that counts the created items per month (that could be status new, or closed. For example: in Jan we create a item and close it after a week. So your measure doesnt count this to new...).

 

- The other line in the chart should show just the closed ones (i think for that is your measure good ;) )

 

You can imagine it like a IT ticket system, you wanna know, how many tickets were opened last month....and how many closed...

I hope I could explain it better ;)