Forum Discussion
Anonymous
7 years agoNot applicable
total doesnt work
Hi, I have a PBI report (SQL Service Analysis direct connection) with a table showing number of surgeries by room, and slicer for RoomFilter. table example: SurgeryRoom NumOfSurgeries ...
v-yuta-msft
7 years agoCommunity Support
Anonymous,
Click [SurgeryRoom] and [NumOfSurgeries] to the chart and click NumOfSurgeies-> Sum, then create a slicer based on [SurgeryRoom].
The result is like below:
Regards,
Jimmy Tao