Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Show Total line when multiple values are selected

‎02-26-2024 12:50 AM

Hi everyone,

I have a usecase where I have to show an additional total line in line chart which displays the sum of the values selected in the slicer only when multiple values are seected. Otherwise when only one value is selected it should show only that line.

Message 1 of 3
450 Views
0
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

‎02-26-2024 06:42 AM

@Anonymous , If you follow the approach in this blog or the column on Legend, you should get a total line for selected legends

 

https://medium.com/@amitchandak/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Message 2 of 3
417 Views
2 REPLIES 2
Anonymous
Not applicable

‎03-14-2024 11:32 AM

Thank you it works

Message 3 of 3
386 Views
0
amitchandak
Super User
Super User

‎02-26-2024 06:42 AM

@Anonymous , If you follow the approach in this blog or the column on Legend, you should get a total line for selected legends

 

https://medium.com/@amitchandak/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 2 of 3
418 Views

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All