Hi there
It looks like I may have bumped up against a Power BI limitation when compared to Excel. Perhaps it's coming in a later release? Perhaps I'm just daft and I'm missed it in Power BI today:
I need to produce a chart that illustrates, by month, the percentage of tickets resolved by each team.
Imagine a table where each row represents a ticket, with attributes: Ticket ID, Resolved month, Resolution team.
In Excel: If I create a pivot chart (line chart) from this table, I can plot x-axis as Resolved month, the legend as Resolution team, and the values as Ticket ID. This is now the cool part: I can alter the Value Field settings (Ticket ID) to not just be Count, but I can show the value as '% of Row Total'. Hurrah! I get a brilliant line chart which shows for any given month what percentage of tickets are closed out by my Service Desk, Infrastructure Team etc etc.
Now, Power BI is great. While I have the same query as the table above, the visualisation are limited. Hmmm. I could manually create a query for each team's resolution numbers against a grouping of Resolved month, and then merge all of the queries together and add columns to reflect the % each team's resolution volume represented, but geez, that's clunky and assumes that I know that numbers of teams that're in play.
Have a I missed something?
Thanks for your help!
