Stacked Visualization using Ratios - Power BI

0
votes

I'm trying to figure out the best way to visualize Active Session History data from Oracle/Postgres without reinventing the wheel. I can collect and model the data just fine, but I'm really struggling to find a visualization that will do anything even remotely close to what this is doing

ASH Viewer Sample

It's an area map with time on the x and count of active sessions on the y, but I can't seem to find a visualization in Power BI capable of mapping all of the different combinations shown, and admittedly and very much still getting my feet wet in analytics and the like.

A couple of examples of what I'm doing with the data model. The core model is: Data Model Example 1 of 2

I've also tried creating sub tables, if you will, of each Wait Type you see color coded below. I know I'm missing something and have probably gotten myself into the weeds, please help me back my way out :)

Questions are:

  1. Does anyone know if there's a viz capable of this in Power BI
  2. Am I way out of bounds for what I'm trying to do in Power BI?
  3. Any thoughts on what the heck I'm doing wrong?

Thanks so much!

Edit: Adding this for Area Stacked Chart. This works great if I'm looking at larger grades of data, like over days, weeks or months. In this case, I'm trying to get a reasonable picture by minute, which ends up looking pretty messy overall. I believe this is because its just plotting my x/y axis data points and isn't actually taking the ratio of waits into account. Area Stacked Chart

Link to example pbix: https://drive.google.com/open?id=16wGvKcbSHXMBNbAhTZQHdgmua0KEWVTB

1
oraclepowerbipowerbi-desktop

1 Answers

0
votes

There's a built-in stacked area chart visual. Broadly speaking, you'd put time on the x-axis and your categorization on in the Legend box which would split out the measure you put into the Value box into different pieces similar to your chart.

Here's an example from Tutorial Gateway:

Stacked Area Chart Example