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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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..
Solved! Go to Solution.
@krrish116 , Try measure like
Bar = sum(Table[Value])
Line = divide([total], calculate([total], allexcept(table, Table[Customer])))
@krrish116 , Try measure like
Bar = sum(Table[Value])
Line = divide([total], calculate([total], allexcept(table, Table[Customer])))
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.