Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
This seems pretty simple but I can't seem to find a solution.
I will give an easy to use example to make my question easier to understand. I have 100 locations in one column, and another column with profit per month for each location. I want to separate the 100 locations into 50 and 50 (for east and west) and have two lines in my chart that represent the two groups to show how east and west rank against one another. Thanks.
Solved! Go to Solution.
@Anonymous
Create a new column in the table that groups the locations into East and West based on your logic then add this new column as a Legend in the line chart.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Create a new column in the table that groups the locations into East and West based on your logic then add this new column as a Legend in the line chart.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!