Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
krrish116
Resolver II
Resolver II

Filter the graph according to selected and total sum of all values

Hi @amitchandak ,

I have a table with 

Customer          Product        Value

John                    car                5

John                    bike              6

John                   plane             8

Carter                car                  4

Carter               plane              9

Greg                 bike                7

Greg                 plane              7

 

In the report we have a slicer and Bar and Line Graph

In slicer we have Product (Single Select).

In bar and line graph we are showing Customer on X-Axis and in Y- Axis we have to show

On bars we are displaying the value of selected product 

On line we have to show the Percentage value like,

 

if the single select is on Plane then

Customer      Bar               Line                             Calculation of Line

John               8             8 / (8+6+5)              Plane Value / Car +Bike+ Plane

Carter            9              9 / (9+4)

Greg              7              7  /  (7+7)

 

Please help me to solve it 

Thanks,

Krish..

 

 

  

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@krrish116 , Try measure like

 

Bar = sum(Table[Value])
Line = divide([total], calculate([total], allexcept(table, Table[Customer])))

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

2 REPLIES 2
amitchandak
Super User
Super User

@krrish116 , Try measure like

 

Bar = sum(Table[Value])
Line = divide([total], calculate([total], allexcept(table, Table[Customer])))

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

Thank you @amitchandak 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.