Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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])))
User | Count |
---|---|
84 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |