Forum Discussion
URGENT - Clustered Column Chart Visual
Hi, I have a clustered column chart visual to show the comparison between the number of due tasks and number of completed tasks per month. There should only be 3 completed task in May however this is not the case. Please help?
5 Replies
- vanessafvg
Community Champion
how are you calculating this?
Hi vanessafvg
I am exporting an Excel file from my Microsoft Planner and adding a formula in the spreadsheet that extracts the month in the short date cells as seen below.
- vanessafvg
ok but what measure type are you using to do the count? you are probably counting rows in the table, you will need to write a new measure that allows you to count only rows when there are values
what measure are you using on your chart?
v-lionel-msftCommunity Support
Hi Anonymous ,
Is this what you want?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi vanessafvg sorry I have been away from my desk all weekend.
The measure I am using on my chart is count. What do I need to do to only count rows with a value? Thanks
