Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So I have one field with a bunch of project statuses. Each status is either in planning or active. I would like to have a single line graph broken up into 2 sections, one with projects in planning and another with active projects.
I created a new field called "Status Grouper" with a Switch statement, categorizing every status as either "Active" or "Planned" accordingly. However, I can't seem to put my Status field and my Status Grouper field on the same graph at the same time! I am pretty new to Power BI, how can I go about this? Thank you very much for your help.
Solved! Go to Solution.
Hi @ailsazheng ,
Currently it it not possible to add such a line in line visual. However we can add the status column into the legend to work around.
For more details, please check the pbix as attached.
Hi @ailsazheng ,
Currently it it not possible to add such a line in line visual. However we can add the status column into the legend to work around.
For more details, please check the pbix as attached.
Thank you Frank!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |