Forum Discussion
Creating a column chart
Is there a way to create a stacked column chart where the X axis is the column headers and the Y axis is the count of No's in the corresponding column? id like to add a slicer to filter by date but building the bones of the chart is my first hurdle.
every time i add more measures to the X axis is doesn't display it.
thank you for your help
| ID | Start time | end time | Which checks are you completing? | are there any open documents? | Checking 3 personnel in work today, are all of their Mandatory competencies in date? | Checking 5 personnel, in total, across shift and support, have they had their appraisal completed? | documentation to be checked for accuracy. Are both compliant? | Have duty crews been assigned for this week and the following week? | Has the Mandatory Training board been updated during the previous month? | Is the notice boards in the T-Bar up to date? | Is the Social notice board in the T-Bar up to date? | |
| 47 | 16/11/2022 07:27 | 16/11/2022 07:27 | anonymous | Personnel weekly | No | Yes | Yes | No | Yes | Yes | Yes | Yes |
| 47 | 17/11/2022 20:06 | 17/11/2022 20:06 | anonymous | Personnel weekly | No | Yes | Yes | No | No | N/A | No | No |
| 48 | 23/11/2022 12:04 | 23/11/2022 12:04 | anonymous | Personnel weekly | No | Yes | Yes | yes | Yes | N/A | Yes | Yes |
| 49 | 01/12/2022 21:35 | 01/12/2022 21:35 | anonymous | Personnel weekly | No | No | Yes | No | No | N/A | No | No |
| 50 | 06/12/2022 07:58 | 06/12/2022 07:58 | anonymous | Personnel weekly | No | No | Yes | Yes | Yes | No | Yes | Yes |
| 51 | 12/12/2022 15:00 | 12/12/2022 15:00 | anonymous | Personnel weekly | No | Yes | Yes | Yes | Yes | N/A | Yes | Yes |
| 2 | 11/01/2023 13:36 | 11/01/2023 13:36 | anonymous | Personnel weekly | no | No | Yes | yes | Yes | Yes | Yes | Yes |
| 3 | 18/01/2023 10:40 | 18/01/2023 10:40 | anonymous | Personnel weekly | No | Yes | Yes | Yes | Yes | N/A | Yes | Yes |
1 Reply
jdanney , in the stacked column chart, you can have more than one measure or legend, you can not have both.
You can try field parameters for the dynamic axis
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
