Forum Discussion
Dynamic Stacked Bar Chart
Hi TomMartens,
Thank you very much for your reply. I really appreciate your help.
I do see that the legend is dynamic and I am able to replicate this with my own file.
Just to provide a little more detail, in my dataset I have a variable listing the severity of each episode. I have then constructed conditional columns for each severity level, from 1 to 10 - so, if for example, an incident of severity level 7 is recorded, it will be listed in the original severity variable (as the number 7) and then also recorded in the constructed conditional column titled "7" with a number 1. To construct the stacked column chart in the screenshot I provided above, I used the conditional columns that I constructed.
I am still relatively new to Power BI, but I have made use of Field Parameters in previous dashboards I have built up. I guess I was wondering if there may be a solution to my question using Field Parameters, DAX expressions... or some other method?
Again, thank you very much for your help.
Kind regards,
Joel