Simple Table?

[PaulSGodden]

Hi,

Have a Power Automate job populating a SharePoint list

and am looking to create a dashboard with a simple table similar to:

Tried a few standard visuals and downloaded a couple but none do the job. Am assuming that I'm looking in the wrong place or its simple pilot error on my person. Any advice gratefully received. Thanks in advance

[Anonymous · Accepted solution]

HI @PaulSGodden,

After you are getting data to power side, you can do unpivoted column on these value fields(high, medium, low) to convert them to attribute and value. Then you can create a matrix with attribute as row , date field on column to reproduce these effects.

Unpivot columns - Power Query | Microsoft Learn

For add custom row to matrix, you may need to create a new table with raw row field value and new values.

Then you can use it on matrix row. You need to write a measure formula to use on value field to use current row context value to lookup row label value and reduce to different calculation formula.

Dynamic Rows and Dynamic Columns in Power BI Matrix visual using Slicers | by Raghvendra Pratap Sing...

Regards,

Xiaoxin Sheng