webharvest
New Member
- Joined
- Apr 20, 2010
- Messages
- 16
I've created a PowerView based on a merged Power Query. Basically I've taking Actual hrs, Estimate At Complete (EAC) and Budget hours from several different sources and linked them by Work Breakdown structure (WBS) in a merged Power Query. I then used PowerView to display the data in a table and used PowerPivot to calculate the % spent to EAC and % spent to Budget. I can display this very nicely in PowerView but I can't figure out how to make it a littel more user friendly. I would like to have all the WBSs rows in the powerview that have a %spent greater than 100% or where the EAC is greater than the Budget turn Red. this way I can make it more visable when I have a problem. I'm fairly new to Power Query, Power Pivot and PowerView so I'm learning on the fly. I would normally do this using conditional formatting but I don't see that available to me in the Power View settings.
Any suggestions would be greatly appreciated.
Any suggestions would be greatly appreciated.