LISA SANDERS on 05 Apr 2022 17:56:15
I need to be able to highlight based on all my columns and rows, not just measures. Currently, there is no way to format Campas, WO Type, or Problem. If the district wants to print my report and hand it out to each principal at a meeting I need to add highlighted/transparent boxes around each one. If the data changes (get larger) I have to move all the boxes around.
Another issue ( with the PBI link example) if I try to see how many Campuses have requested water bottles I can't get a total.
Table Example: see another example via PBI
Campus Work Order Type Problem Requested In-progress Completed
Eastside HVAC Not cooling 3 2 202
Plumbing Broken pipe 1 0 45
Flowermound HVAC Not Cooling 10 3 190
Not Running 1 0 8
Controles 3 1 82
Plumbing No hot water 1 0 5
Cloged sink 4 8 68
Grounds Lawn 2 0 140
- Comments (1)
RE: Format "ALL" based on row or column, not just measures
Well, the formating didn't stay. Please see PBI Example