Forum Discussion
Visual % Days Worked
I work in a company that lends equipment and machinery for construction projects. I have +100 equipment, each identify by an unique ID. I have a log of all the borrowed equipment.(Status: "Ac...
Hi iandespradel ,
Do you want to show a pie chart and 100% column chart like this? You can refer the page 2 in the pbix that we attached.
If yes, you need to create two measures for pie chart.
Broken = CALCULATE(DISTINCTCOUNT('00_CONTROL'[Fecha]),FILTER(iStatus_Eq,iStatus_Eq[Status.Eq]="Broken"))
Total with no Broken = CALCULATE(DISTINCTCOUNT('00_CONTROL'[Fecha]),ALLSELECTED('00_CONTROL'))-[Broken]
Then you can add a slicer to control the Month.
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.