Forum Discussion
traffic light summary
Hi
I have created a simple table which shows the progress of activities using conditional formatting. I would like to create a traffic light summary at the top to show number of activities which are Not started, In progress and Complete. The icons are Red, Yellow and Green. I am just stuck in creating the summary count. Currently if I click on the icon, Power BI will filter the records to the relevant status. Does any one know how can I do the summary count? the outcome I want is eg if the user click on a particular slicer, in this case the department, then it will show how many activities are in red, yellow and green. Thanks.
Hi Anonymous
If I understood you correctly, then a simple distinct count will do the job.
You can even show the qty of every status's activities on the slicer itself:The pbix with the example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
Hi Anonymous
If I understood you correctly, then a simple distinct count will do the job.
You can even show the qty of every status's activities on the slicer itself:The pbix with the example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
Yes of course, but you don't need it if you are using slicers / filters/visuals with filter context .
Count of specific for specific status dax formula is :In_progress_qty = CALCULATE(DISTINCTCOUNT('Table'[Category]), 'Table'[status]= "In progress")
the same formula for every status:
the updated pbix is attachedIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly