Forum Discussion
Bar chart filtering specific records
Good afternoon and thank you in advance for your help. I have a table with business opportunities, with the fields ID, status, and date. I would like a bar chart in which, upon selecting a date, the ...
Hi pakovic
Please try this formula :
Contar = if(max('oportunidades'[estado])<>"pendiente",
COUNT(oportunidades[id]),
CALCULATE(COUNT('oportunidades'[id]),all('Calendar')))
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
But if I select April, I don't see the Pendiente. Is there any way to show me the 3 bars, maybe showing the accumulated? how could I put the formula?